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

[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

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