Page 1 of 1

php mysql comments/forum layout

Posted: Mon Oct 10, 2005 10:51 am
by birdie
hi, ive made a script where php INSERT's data into a table. a table which has "poster" "comment". could anyone please tell me how to echo these results starting from the newest to the last result? use the same kind of layout as a forum if that helps.. o and has timestamps got any use in this? thanks for reading

Posted: Mon Oct 10, 2005 3:43 pm
by feyd
so long as you never delete any records you don't absolutely need a time related field.. to answer your question look into the ORDER BY clause and the DESC (descending) modifier

Posted: Mon Oct 10, 2005 4:07 pm
by birdie
ok thanks i'll try that