Order by wont work

[kvnirvana]

Any idea why I cant get the order by to work?

 

$res =  mysql_query ("SELECT COUNT(*), LEFT(`comment`, 3) AS truncated from comments where navn='$rows[navn]' AND adresse='$rows[adresse]' ORDER BY time desc" ) or die(mysql_error());

[ManiacDan]

The error message would probably help, since you're using an aggregate column without the GROUP BY clause. 

 

-Dan

[PFMaBiSmAd]

It would help if you posted an example of the time column data values, the actual result, and the expected result.

 

Just telling us that it doesn't work, doesn't convey any useful information.

[kvnirvana]

There is no error, I just can't get it to do the order by.

Say i have a tabel called comments. to every comment there is a time that shows when it was posted. I want the query to show the comments ordered by the latest. At the moment it shows the last comment no matter what I do.

[BlueSkyIS]

if you order by time desc, you will get the last comment as it has the latest time.

 

[kvnirvana]

Doesn't matter I fixed it, but thanks anyway :=)

[ManiacDan]

Then post what you did to fix it so that others may benefit.

 

Also, there are 4 additional errors on this line.

 

-Dan

[kvnirvana]

It had nothing to do with the query, it was somthing to do with where i placed the query in my full code.  where do you see 4 additional errors?

[ManiacDan]

3, really.  You don't quote your array indexes, you don't wrap your interpolated variables in curly braces, and you use the 'or die' syntax, which is sloppy.  Handle errors properly.