Order by Desc Limit

[JackieB]

GROUP BY linkid ORDER BY hits DESC LIMIT 0, 4

Shouldn't this line pull 4 urls and descriptions?

There are 6 URLs on the site and it is showing all 6.

Thanks,
jackie

[ajs83]

did you try

GROUP BY linkid ORDER BY hits DESC LIMIT 4

?

[JackieB]

Thank you for the reply.

Its still returning all 6.

Jackie

[JackieB]

it is still returning all 6. Does anyone know why either the code is broken or could something somewhere else be over riding the command?

Thanks,
Jackie

[jatar_k]

try dropping the GROUP BY

if there are only 6 then you could just have

select * from mytable ORDER BY hits DESC LIMIT 4

if that works then move on from there

[JackieB]

There will be many more than 6, but at any time the most I need pulled is 4.

Thanks,
Jackie

[coopster]

Which database (and version), MySQL? Can you offer the full query statement here?