Re: Strange error on mysql_fetch_array

dunno.... but my it's just failing at the mysql_connect() shouldn't you specify the password too? <tjacobs-php@codegnome.org> wrote in message news:Pine.LNX.4.33.0106261356390.29634-100000@cyrix.codegnome.org... > 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 > > -- > Todd A. Jacobs > CodeGnome Consulting, LTD > > > > -- > 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 >