I would like to ask how to insert entries in mysql using php on top of the table or should I say as the first row in the table so that when I query all entries- I would get the most recent once on top of the list... please help. thanksz

i need code or any suggestions to take my project database backup in to any hard drive

Hi all-
I want to know about the best host for jsp and mysql.
I need about 5GB of web space and it would be better if database space is unlimited.It would be better if one provides the list of host based on the space-reliability-support and cost.

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