> -----Original Message-----
> From: Louis Huppenbauer [mailto:louis.huppenba...@gmail.com]
> Sent: Tuesday, February 07, 2012 9:24 AM
> To: ad...@buskirkgraphics.com
> Cc: php-general@lists.php.net
> Subject: Re: [PHP] 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 <ad...@buskirkgraphics.com>
> 
> > 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

Reply via email to