|
|
Posted by Rik on 07/17/06 14:36
Sutha Balasubramaniam wrote:
> Can someone please tell me what's wrong with this query?
>
> mysql_query("SELECT a,b,c,d,e FROM my_table WHERE d!='0' && a='1'
> GROUP BY b ORDER BY c DESC LIMIT 21");
>
> This returns nothing! Appreciate any helps.
echo mysql_error();
It's probably the GROUP BY clause.
If there are several possibilities for c,d & e where b is the same, the
server doesn't know what to show.
Test:
mysql_query("SELECT a,b FROM my_table WHERE a='1' GROUP BY b LIMIT 21");
and:
mysql_query("SELECT a,b,c,d,e FROM my_table WHERE d!='0' && a='1' GROUP BY b
ORDER BY c DESC LIMIT 21");
To see if the rest of the query is OK.
Grtz,
--
Rik Wasmus
Navigation:
[Reply to this message]
|