syntax question

From: 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 .

« previous php.general (#316522) next »