Re: syntax question

From: Date: Tue, 07 Feb 2012 14:24:29 +0000
Subject: Re: syntax question
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-316523@lists.php.net to get a copy of this message
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@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ã[øøót > }WiõC.seller_id AND > IF(table2.name='juice','No > Juice for YOU', > table2.name=table2.nameæ[Š > `¶Æ Άèû " q) 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', table2V > poãQÍd§c©³«ƒ†ò.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 (#316523) next »