Re: Strange error on mysql_fetch_array

----- Original Message ----- From: "David Robley" <huntsman@www.nisu.flinders.edu.au> To: <tjacobs-php@codegnome.org>; "PHP General" <php-general@lists.php.net> Sent: Wednesday, June 27, 2001 8:47 AM Subject: Re: [PHP] Strange error on mysql_fetch_array > On Wed, 27 Jun 2001 06:31, tjacobs-php@codegnome.org wrote: > > The following code fragment works properly, in that I get the output > > I'm expecting. However, if I don't disable error messages with @, I get > > an error message from PHP saying: "Warning: Supplied argument is not a > > valid MySQL result resource in /var/www/htdocs/cgcm/test2.php on line > > 9." > > > > How can the resource be invalid if I'm getting the results back? I'd > > appreciate any explaination. > > > > $connection_id = @mysql_connect ('localhost', 'root') or > > die('No > > connection.'); > > $database_id = @mysql_select_db ('cgcms', $connection_id) or > > die('No connection.'); > > > > ... > > > > $result_id = @mysql_query("DESC $table_name $field_name"); > > $row = mysql_fetch_array($result_id); # This is line 9 > > Try using mysql_error() to see if there is some feedback from mysql. Put > it just after your mysql_query(). > > -- > David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc > CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA > > Common sense isn't... > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net Hmm, maybe the prefix '@' suppresses the returning link-identifier. Just a suggestion! -- RM