Re: mysql_fetch_array issues.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux