mysql function error

ziycon · #1 (**permalink**) 07-03-2008, 12:45 AM

I can't seem to see the problem here, its saying the while.... line is giving this error(this function works on other function calls):

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Apache\htdocs\sys_config\sql.php on line 192

PHP Code:

  function check_admin_userid($id) {
    $validate = false;
    $sql = mysql_query("SELECT userid FROM admin_level WHERE userid = ".$id." AND level = 0 LIMIT 1");
    while ($row = mysql_fetch_array($sql)) 
    {
        if($row['userid'] == $id)
        {    
            $validate = true;
        }
    }
    return $validate;
}

Frodo · #2 (**permalink**) 07-03-2008, 01:17 AM

I would say you have closed your mysql connect somewhere before you called this function. Do you use mysql_close();

EDIT: why are you using a while loop that sql statement should only return one value, no? just to be safe?

ziycon · #3 (**permalink**) 07-03-2008, 01:23 AM

Quote:

Originally Posted by Frodo

I would say you have closed your mysql connect somewhere before you called this function. Do you use mysql_close();

Your a star, after looking at this code for so long you really need a fresh pair of eyes!

Quote:

Originally Posted by Frodo

EDIT: why are you using a while loop that sql statement should only return one value, no? just to be safe?

Force of habit.

Frodo · #4 (**permalink**) 07-03-2008, 01:38 AM

Had a similar problem a while back, left it for a week or two, came back and was like how did I not spot that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ASP VB, MYSQL and ODBC error ASP 0115	matt-dublin	Coding Help	4	13-09-2007 01:39 PM
PHP mySQL Problem!?	ziycon	Server / Technical Administration Tips and Queries	1	15-07-2007 08:31 PM
mysql	3rigena	Webmaster Discussion	4	24-05-2007 09:33 PM
PHP function giving trouble.	louie	Coding Help	1	26-01-2007 11:51 PM

Sponsored links

mysql function error

mysql function error

Similar Threads

Sponsored links