Works from the command line but NOT from PHP
| From: | DonPro | Date: | Tue, 01 Oct 2002 16:20:20 +0000 |
| Subject: | Works from the command line but NOT from PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-118387@lists.php.net to get a copy of this message | ||
Does anyone have any experience with FULLTEXT indexed MySQL tables? I've
created such a key. When I type the following from the MySQL command line,
I get the desired records returned, i.e., a subset of my entire table:
SELECT HSCode, UOM, EDescript FROM HSCodes WHERE MATCH(EDescript) AGAINST
('exercise');
However, the following PHP code returns the entire table, i.e., every single
column and I don't know why:
$queryID = mysql_query("SELECT HSCode, UOM, EDescript FROM HSCodes WHERE
MATCH(EDescript) AGAINST ('" . $description . "') ORDER BY HSCode, UOM,
EDescript");
if ($queryID) {
while ($queryRow = @mysql_fetch_assoc($queryID)) {
echo '$queryRow[HSCode] . ' | ' . $queryRow[UOM] . ' | ' .
$queryRow[EDescript];
}
}