I made something where people can comment on a page, the columns are (id, comment) The ID is a timestamp, and the comment is their comment. How can I have mysql order the rows so that it gets the rows with a lower number timestamp(id) before the larger ones.
Example:
1052147030
Listed Before
1052170901
Not a very good explanation, but see if you understand.
select * from table order by id; //use the order by clause
So that orders for example 1-100 in timestamp format?
it should
I feel dumb, the actual table had (id, time, comment) the time being the time that the user commented on, the id was the thing it did comment on, i was using id, when i should've been using time. Anyways im an idiot, thanks though.
