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 .
