Hello.
Not enough information to make a conclusion. For example, this can be a bug: http://bugs.mysql.com/bug.php?id=6523 where fulltext indexes doesn't work with subqueries. Can you provide a repeatable test case? Can you check if problem remains if you upgrade to latest release? Does mysql_error() return the error right away after executing the query? "leegold" <[EMAIL PROTECTED]> wrote: > Getting the following runtime error messages on a Solaris server, Mysql > 4.1.7 > PHP 5.0.1: > > I try to search and: > > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL > result resource in /data/labweb/htdocs/getit/search010.php on line 123 > > Warning: mysql_num_rows(): supplied argument is not a valid MySQL result > resource in /data/labweb/htdocs/getit/search010.php on line 175 > > > 1. Line 123: for( $i = 1; $row = mysql_fetch_array($result); $i++ ) > {... > Line 175: $num_rows = mysql_num_rows($result); > > 2. The $result variable causing the problem is from a FullText query. > Another $result variable done with a non-fulltext search (ie. a non > indexable sub-string %keyword% search) in the same script works fine and > does not cause errors. > > 3. The same exact script works fine on my windows "localhost" test pc. > w/php 4.3.6,Mysql 4.1.3. > > What could be the cause? > > Thanks, > Lee G. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
