My Recent Searches All of FAQTs Php Knowledge Base MySQL Folder

Did You Find This Entry Useful? 0 of 1 people (0%) answered Yes Recently 0 of 1 people (0%) answered Yes

Entry

table sorted by the addition of fields ??

Dec 3rd, 2001 08:10
ditoiu cristian, Ansgar Windges,

1.add a field called id (or smth) autoincrementing and the the select
should be 
select field1,filed2,id order by id DESC . 
2. add a timestamp field (timest) and the do
select field1,field2,timest order by timest desc.
the first method is better (you don't have to worry about the insert 
modifications)