this error only means that your msql_query($result) was correct, but did not have any result... meaning, there was nothing to select, there for there is nothing to fetch... hence you can not do a msql_fetch_array() on an empty result set. KD On Wed, 9 Jul 2003, Greg Hetrick wrote: > Yup, I have all permissions -- it appears that I can access mysql but not > the database itself. > > "Gary Every" <Gary.Every@ingramentertainment.com> wrote in message > 309419457839D4119E0D00508B6DFE0B0828E4FF@iei-lavergne.mdf.lvrgn.nexus">news:309419457839D4119E0D00508B6DFE0B0828E4FF@iei-lavergne.mdf.lvrgn.nexus.. > . > > Do you have select permissions on that DB/table? > > > > If you have GRANT permissions, try > > GRANS SELECT, INSERT, UPDATE, DELETE ON db.tablename to > > 'youruser'@'your.ip.address' IDENTIFIED BY 'yourpassword'; > > > > your.ip.address can be substituted with localhost if you're on the same > box. > > > > > > Gary Every > > Sr. UNIX Administrator > > Ingram Entertainment > > (615) 287-4876 > > "Pay It Forward" > > mailto:gary.every@ingramentertainment.com > > http://accessingram.com > > > > > > > -----Original Message----- > > > From: Greg Hetrick [mailto:ghetrick@avalon.net] > > > Sent: Wednesday, July 09, 2003 12:31 PM > > > To: php-db@lists.php.net > > > Subject: Re: mysql_fetch_array issues. > > > > > > > > > I do not have the die statment -- the DB is the same except > > > the name and I > > > have double checked that I just did a back up of the previous > > > db and moved > > > it to the new server. I have done some more digging, my query > > > appears to > > > work, but I almost appears that I have a problem with selecting the > > > database -- > > > if I comment out the mysql_select -- statment I get the same > > > error, perhaps > > > I just can't get to that DB. > > > intresting. > > > > > > I guess I can assume at this point there is something flaky with my DB > > > > > > > > > "Jeffrey N Dyke" <jeffrey_n_Dyke@Keane.com> wrote in message > > > OF34955652.B9ABBCBE-ON85256D5E.005C604A@keane.com">news:OF34955652.B9ABBCBE-ON85256D5E.005C604A@keane.com... > > > > > > > > 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: > > > > Subject: > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
