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')"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php