php wiev from today to latest posts

[auriaks]

How I need to change this:
mysql_query("SELECT * FROM reg_users ORDER BY `date` LIMIT 15")

to show latest replies from today written to latest??

[Schmoopy]

mysql_query("SELECT * FROM reg_users ORDER BY `date` DESC LIMIT 15")

Should do the trick.

[auriaks]

$queryget = mysql_query("SELECT * FROM forum_ans ORDER BY `date` AND `time` DESC LIMIT 6") or die("Error with query");

Im using this... Not working.
Maybe other options?

[Schmoopy]

Change to:



$queryget = mysql_query("SELECT * FROM forum_ans ORDER BY `date`,`time` DESC LIMIT 6") or die("Error with query");