Posted by Jochem Maas on 03/24/05 17:29

Richard Lynch wrote:

....

>>$how_many = mysql_result(mysql_query("SELECT COUNT(*), MATCH(ad_sub,
>>ad_text) AGAINST('$words') AS score from ".$tcname."ads WHERE
>>MATCH(ad_sub,
>>ad_text) AGAINST('$words') FROM ".$tcname."ads where is_confirmed=1"),0);
>
>
> Hmmmm. Actually, I *can* tell you that you shouldn't have FROM in there
> twice. You've messed up your query something awful with that.
>

also he just wants the count with this statement so:

'MATCH(ad_sub,ad_text) AGAINST('$words') AS score'

shouldn't be part of this query, instead:

"SELECT COUNT(*) FROM ".$tcname."ads where is_confirmed=1 WHERE MATCH(ad_sub,ad_text) AGAINST('$words')"

• Next in forum: Meed a multiple merchant shopping cart please
• Prev in forum: Re: [PHP] if statement probable bug
• Thread view: Re: [PHP] count with match probelm

[Reply to this message]