mySQL question

[Derek Atkins]

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