syntax question
| From: | admin at buskirkgraphics dot com | Date: | Tue, 07 Feb 2012 14:11:46 +0000 |
| Subject: | syntax question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-316522@lists.php.net to get a copy of this message | ||
I have been struggling with this issue for an hour and honestly I am not
sure why.
I consider myself to be pretty savvy with MySQL but I am running into an
syntax error that is just flat out eluding me.
$query = "SELECT
table2.name from table1
,table2 WHERE
table2.user_id=table1.seller_id AND
IF(table2.name='juice','No
Juice for YOU', table2.name=table2.name)
LIMIT 1";
This query works!!
But If I try to add a GROUP BY to the query, complete failure.
$query = "SELECT table2.name FROM table1
,table2 WHERE
table2.user_id=table1.seller_id AND
IF(table2.name='juice','No
Juice for YOU', table2.name=table2.name)
GROUP BY table1.ID
LIMIT 1";
The main goal here is to get only 1 return but MySQL is returning the same
row 2 times.
Before I beat my head in anymore I will toss this out to you guys and beat
myself up later for not drinking enough coffee or something .