Re: mysql_fetch_array issues.
| From: | jeffrey_n_Dyke at Keane dot com | Date: | Wed, 09 Jul 2003 16:53:06 +0000 |
| Subject: | Re: mysql_fetch_array issues. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29177@lists.php.net to get a copy of this message | ||
Do you have an 'or die(mysql_error())' statement following your
mysql_query($result) line. 99% of the time, this error means your query
failed. if it works on another server....are the fields the same, the
dbname, the tablename?
hth
jeff
"Greg Hetrick"
<ghetrick@avalon. To: php-db@lists.php.net
net> cc:
net>
Subject: [PHP-DB] mysql_fetch_array issues.
07/09/2003 12:04
PM
I am getting the following error when attempting to pull data out of a
mysql
DB
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/pffl/public_html/pffl/webpage/html/dataentry.php on line
125
I can take this same code to a different web server and it is pulling
correctly!
I am currently running Apache 2.0.46 with PHP 4.3.2 I was running Apache
1.3.x with PHP 4.3.1 and getting the same thing, any ideas? here is the
chunk of code where I use the function.
while ($myrow=mysql_fetch_array($result))
{
?>
<option value="<?print $myrow['name'];?>, <?print
$myrow['team'];?>"> <? echo $myrow["name"]; ?></option>
<?
}
Any Ideas.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php