Argggg! Simple syntax killing me!

[bobnew32]

Ok I know anyone here can tell me what extra word to put in this select statement, b/c when I use, it doesnt order it correctly, it does it from the lowest time stamp! (ie May 2 instead of may 4) and its killing me!

$sql = "SELECT * FROM Television_News ORDER BY time_stamp LIMIT 25 ";

[jatar_k]

SELECT * FROM Television_News ORDER BY time_stamp desc LIMIT 25

[mysql.com...]

is that what you mean? ASC ¦ DESC after order by?

[bobnew32]

Your a lifesaver! It worked perfectly thx alot, and btw is there somthing wrong with the time in here?

[jatar_k]

yes, some kind of date bug, should be worked out over the next day or so. It makes threads a little hard to find for now.