> -----Original Message----- > From: Louis Huppenbauer [mailto:louis.huppenbauer@xxxxxxxxx] > Sent: Tuesday, February 07, 2012 9:24 AM > To: admin@xxxxxxxxxxxxxxxxxxx > Cc: php-general@xxxxxxxxxxxxx > Subject: Re: syntax question > > Generally... Wouldn't grouping by an id (which is normally unique) have > no > real benefit... Except some strange behaviour? > > Just to clarify: Why aren't you sticking to the LIMIT 1? > > 2012/2/7 <admin@xxxxxxxxxxxxxxxxxxx> > > > 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 . > > > > There is no real reason to have a LIMIT It was just yet another attempt to limit the results during the testing. After reading my post back I see an error in the IF statement but not the resolution to the issue. The IF should read IF(`table2`.`name`='juice',`table2`.`name`=`table1`.`code`, `table2`.`name`=`table1`.`ref`) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
