I have a book that uses mysqli in all of the examples but online tutorials that I have seen use mysql (no i ). I m not sure what I should be using or what the difference is.

I thought I heard the i version is for use with a newer MySQL server- but I m really not sure.

I am looking for a free open source forum script and I would like to be able to have a "latest posts" modual on my html homepage. I have a host with php4/5 and I have plenty of mysql databases. If you are using a similar forum or know of one then please advise me where I can find it.

Thanks in advance

HI im getting a syntax error in my MYSQL statement- im pretty sure its because the text im adding contains an apostrophre ( ) and cancels out the PHP coding- somehow. but im not that smart in the sense of figuring out how to fix the problem- heres the coding:

//If HTTP Protocol POST is invoked then store form data in local variables and UPDATE the homepage table with the values.
if(isset($_POST[ update ]))
{
$Id = $_POST[ Id ];
$title = $_POST[ title ];
$content = $_POST[ content ];
// update the article in the database
$query = "UPDATE main_page SET title = $title - content = $content ";
mysql_query($query) or die( Error : . mysql_error());
echo "Article $title updated";

}

Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near this is the north s website at line 1

Hi.

I m going to build a high scale site in php/mysql that needs to scale horizontally.

What things should the developer do and not do when writing the code and creating the database?

Thanks.

I want to make a blog and I should want to add a comment box too. What I can do. I know how can I create a form. I know to crate databases and tables. but I don t know how can we store comments. Do I want to create 1 column for 1 comment? Then If there 10 comments I want to create 10 columns. but that is not possible because i want to create 1 form for 1 comment. Then where can I store the comments. Please give the answer..please....