Hello there,
I have that problem that PHP order my mysql search wrong...
I wrote: $result = $mysql_query("select * from DATABASE where id > 0 order by id desc");
IT WORKS, BUT THIS DON'T!!
I wrote: $result = $mysql_query("select * from DATABASE where id > 0 order by number and id desc");
IT HAVE TO ORDER FIRST BY NUMBER, AND THEN ID, but nope, it doesn't.
Can I use ()'s ? And can I only write "decs" once? and number also be decs? If I do that, I got an error...
Thanks, ULRIK
I have that problem that PHP order my mysql search wrong...
I wrote: $result = $mysql_query("select * from DATABASE where id > 0 order by id desc");
IT WORKS, BUT THIS DON'T!!
I wrote: $result = $mysql_query("select * from DATABASE where id > 0 order by number and id desc");
IT HAVE TO ORDER FIRST BY NUMBER, AND THEN ID, but nope, it doesn't.
Can I use ()'s ? And can I only write "decs" once? and number also be decs? If I do that, I got an error...
Thanks, ULRIK