php/mysql timestamp queries

[birdieserver]

hi, does anyone know how to set variables to the newest added result in a table (table has timestamps)? ive tryed my own script but this is the furthest i could get..

$page1 = mysql_query("SELECT * FROM extrapages ORDER BY time_stamp_col DESC LIMIT 5");

I'm aware that this sets 5 of the results to one variable; is there any simple way to narrow it down so you can have 5 seperate variables which each have one different result.
Any ideas? thanks

 

[vbkris]

>>hi, does anyone know how to set variables to the newest added result

have an id to that row and use it?

for reading auto generated ids there is a mysql_last_insert_id() method...

Known is handfull, Unknown is worldfull

 

[birdieserver]

ive researched the mysql_last_insert_id() function and i cant even find any info on it on php.net. could you please tell me how to basically use it?

 

[sleipnir214]

Someone mispoke. The function is called mysql_insert_id()

However, you should have been able to find it on the online manual MySQL section


Want the best answers? [url=http://www.catb.org/~esr/faqs/smart-questions.html]Ask the best questions!

TANSTAAFL!!

 

[vbkris]

oops, sorry for the blooper...

Known is handfull, Unknown is worldfull