Hi! i was wondering how to sort my database. i want to make a news table but every time i post it goes to the bottom of the table. so i want to sort the table by the time its posted (i put the time in a time column in the news table ), any ideas? id like to put the new data on top OR sort the table so it goes to the top. plz help!
Thanks in advance!
Use ORDER BY in SELECT query.
Clustering of data is used to speed up certain queries. For myisam tables, myisamchk -R index_name table_name.MYI
