Problem in displaying inbox

[ishlux]

Hi all,
I have created an inbox......which will show list of values......
if some new data added in inbox......it will be the last in the inbox table. i want the new entries
should appear first.

can u help me out...........

[praveen_dusari]

hi,
in sql query write like this 'ORDER BY id DESC' this may help u

[ishlux]

Hi i wrote this statement but still its not working ..........i want the recent date which has entered should appear first............

$selcount = "SELECT * FROM autoalto_mail ORDER BY date DESC" ;

[Shanti C]

you just sort your table by id ,no need of sort by date..because your id is auto incremented one....

$selcount = "SELECT * FROM autoalto_mail ORDER BY auto_id DESC" ;

[saikishore]

Hi..
i hope this is useful to u....
$selcount = "SELECT * FROM autoalto_mail ORDER BY primarykey column name DESC" ;