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 t

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 ar

[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 ('