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: [PHP-DB] 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: [PHP-DB] 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