TalkPHP - View Single Post - Re-order display of data-base

tony · 05-24-2012, 05:40 PM

does your table only has the fields name and comment? you would need an extra field that would hold the date and time when the comment was created then you can order them. For example lets say the field is named created, the sql query would be something like this

sql Code:

SELECT * FROM $tbl_name ORDER BY `created` DESC

the DESC is for descending order, the other option is ASC for ascending order.

I hope this helps.

05-24-2012, 05:40 PM	#2 (permalink)
tony The Addict Join Date: Aug 2008 Posts: 336 Thanks: 8	does your table only has the fields name and comment? you would need an extra field that would hold the date and time when the comment was created then you can order them. For example lets say the field is named created, the sql query would be something like this sql Code: SELECT * FROM $tbl_name ORDER BY `created` DESC the DESC is for descending order, the other option is ASC for ascending order. I hope this helps.