Sorry,
Tried error_reporting()? The query is invalid that's sure. Maybe '0' is not
integer value (i dont know well mysql)...
(or is there any mysql_error() to get mysql's error, why were the query
invalid?)
Tibor
----- Original Message -----
From: "David Rice" <haloplayer@hotmail.com>
To: <oldw@debian.org>; <php-db@lists.php.net>
Sent: Sunday, March 02, 2003 4:59 PM
Subject: Re: need help with fetching a result using a function
>
> You haven't thorougly read my message, about 4/5 lines down i have said
> "(yes it is included in a script that connects to the database i am
using)"
> :)
> i have another script that calls this function script, and at the top of
it,
> it calls a script that contains my connection information.
>
> I have tested it with other queries that work... and there is no problem,
i
> am definately connected to the database
>
>
>
>
>
> >From: Koleszár Tibor <oldw@debian.org>
> >To: "David Rice" <haloplayer@hotmail.com>
> >Subject: Re: need help with fetching a result using a function
> >Date: Sun, 2 Mar 2003 16:54:25 +0100
> >
> >Hello,
> >
> >You have forgotten to connect :)
> >This error occurs when the $result variable is false and it is not
> >a resource (database query) id.
> >
> >Tibor
> >
> >PS:
> >for any db:
> > $conn_id = connect(...);
> > $result_id = query($conn_id, ....);
> > $row = fetch($result_id);
> >
> >...
> >
> >
> >
> >----- Original Message -----
> >From: "David Rice" <haloplayer@hotmail.com>
> >To: <php-db@lists.php.net>
> >Sent: Sunday, March 02, 2003 4:49 PM
> >Subject: need help with fetching a result using a function
> >
> >
> > >
> > > I am trying to write a few functions for a project i need to do for
> >school,
> > > this function should return all the inactive, or active users (1 or 0
> > > staffstatusid) as an array for creating a drop down menu.
> > >
> > > Now when i perform the following code (yes it is included in a script
> >that
> > > connects to the database i am using) it returns the following error.
> > >
> > > "Warning: Supplied argument is not a valid MySQL result resource in
> > > /home/filterseveuk/public_html/project/getusers.php on line 7"
> > >
> > > and underneath the error it prints the value of var_dump($data)
> > > which is " NULL"
> > >
> > > any ideas how to fix this?
> > >
> > >
> > > =================================================================
> > > <?
> > > function getusers($status){
> > >
> > > $query = "SELECT FROM Staff WHERE Staffstatusid = '$status'";
> > > $result = mysql_query($query);
> > > $row = mysql_fetch_array($result);
> > > $users[$status] = $row ;
> > > return $users[$status] ;
> > > }
> > > $status = 0 ;
> > > $data = getusers($status);
> > > var_dump($data);
> > >
> > > echo $data;
> > > ?>
> > >
> > > _________________________________________________________________
> > > Use MSN Messenger to send music and pics to your friends
> > > http://messenger.msn.co.uk
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > >
>
> _________________________________________________________________
> Overloaded with spam? With MSN 8, you can filter it out
>
http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059
>
>
> --
> 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
