mysql most recent additions to a table

[Anon]

I would like to know if anyone knows how to get php to read the most recent additions to a table, I can get it to display my entried in the table but i would like to know how to get it to display the most recent additions to the table

Can someone please help me

[toma42]

Add a timestamp column and do a select with that column in your order by clause then limit to the number you want to view.

[kparker]

Or an autoincrement column--these are going to be in ascending order, too.

[Anon]

hrm is there anyone that could possibly show me how to do it so that it displays the 5 most recent ? if the column is named col_date
and the date setup is 0000-00-00 do i just do a WHERE col_date IS > 2001-31-3 ?

that is where i am confused i have a column setup setup so i can enter a dateim just confused as to hwo to get it to diplay 5 of the most recent submissions

[Anon]

could you possibly show me how the order of the select would go?

code wise please

[Anon]

..

[Anon]

Well, let's clarify. "5 of the most recent submissions" is quite a different matter than "THE 5 most recent submissions", so which is it?

For the former:

  select * from table order by col_date desc limit 5;

will do. You will get no more than 5 rows, and their dates will not be earlier than any non-displayed rows. (Notice the careful weasel-words.) But if you really want THE 5 MOST RECENT, you can't do without an autoincrement column. Then you say:

  select * from table order by unique_id desc limit 5;