mySQL question

[warlord at MIT.EDU (Derek Atkins)]

Please CC all your responses to discuss at blu.org, not to me.  I am not
a mySQL expert.  In fact I've never run the beast, so I honestly have
no idea how to "fix" it.  You can try "installing mysql" as the apache
user, or reading the apache, php, or mysql docs..

Or you can ask on discuss, and someone _else_ might have an idea...

-derek

"Mike Volmar" <mvolmar at fruitlands.org> writes:

> How do I solve it? Permissions seem hard to deal with in mySQL.
> 
> -----Original Message-----
> From: Derek Atkins [mailto:warlord at MIT.EDU]
> Sent: Wednesday, December 04, 2002 4:33 PM
> To: Mike Volmar
> Cc: discuss at blu.org
> Subject: Re: mySQL question
> 
> 
> Perhaps your web server is not running as root, then, and this is a
> permissions problem?
> 
> -derek
> 
> "Mike Volmar" <mvolmar at fruitlands.org> writes:
> 
> > I can run 'select * from events' from the mysql> proimpt just fine, but
> only
> > when logged in as the root linux user.
> >
> >
> > -----Original Message-----
> > From: Derek Atkins [mailto:warlord at MIT.EDU]
> > Sent: Wednesday, December 04, 2002 4:09 PM
> > To: Mike Volmar
> > Cc: discuss at blu.org
> > Subject: Re: mySQL question
> >
> >
> > Perhaps '$result' contains an error (because mysql_query() returned
> > an error)?  Can you run this query by hand against your MySQL DB on
> > Linux?
> >
> > -derek
> >
> > "Mike Volmar" <mvolmar at fruitlands.org> writes:
> >
> > >   mysql_select_db("events");
> > >   $query = "select * from events";
> > >   $result = mysql_query($query);
> > >
> > >   $num_results = mysql_num_rows($result);  // this line throws error
> >
> > --
> >        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >        Member, MIT Student Information Processing Board  (SIPB)
> >        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >        warlord at MIT.EDU                        PGP key available
> >
> 
> --
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
> 

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available