Re: syntax question
| From: | Louis Huppenbauer | 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 .
>
>
>
>
>
>
>
>
>
>