Re: [PHP] Works from the command line but NOT from PHP
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... DonPro wrote: $queryID = mysql_query(SELECT HSCode, UOM, EDescript FROM HSCodes WHERE MATCH(EDescript) AGAINST (' . $description . ') ORDER BY HSCode, UOM, EDescript); I don't see what is wrong but try echoing the text of the query itself and see if it contains what you think it does around the $desription area. HTH Chris Two bob says this is a register_globals problem -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Works from the command line but NOT from PHP
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]; } } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Works from the command line but NOT from PHP
DonPro wrote: $queryID = mysql_query(SELECT HSCode, UOM, EDescript FROM HSCodes WHERE MATCH(EDescript) AGAINST (' . $description . ') ORDER BY HSCode, UOM, EDescript); I don't see what is wrong but try echoing the text of the query itself and see if it contains what you think it does around the $desription area. HTH Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php