Supplied argument is not a valid MySQL result resource

[jael]

i've writen a php program to fetch array from mysql ..
however this line has error...

if ($row = mysql_fetch_array($result)){

it is a simple fetch result and i can't find out the bug....
anyone can help me??

the error message is:

Warning: Supplied argument is not a valid MySQL result resource in /home/clc/www/html/login.php on line 11

Warning: Cannot add header information - headers already sent by (output started at /home/clc/www/html/login.php:11) in /home/clc/www/html/login.php on line 22

the programe is:

<?php
require 'common.inc' ;

$query="select * from user where name='$user' and password='$password';";

mysql_connect($host,$user,$password);
mysql_select_db($database);
$query = stripSlashes($query);
$result = mysql_query($query);

if ($row = mysql_fetch_row($result)){
	if($row[3]==3){
	header("Location:paullink.php?$level=3"); 
	exit(); 
	}
	else if($row[3]==4){
	header("Location:paullink.php?$level=4"); 
	exit(); 
	}
}   
else{
	header("Location:paullink.php");
	exit(); 
}

?>

[Kristopher]

This is most likely an error that is occuring in the mysql_query. Try throwing on "or die(mysql_error());" for a more accurate error.

$result = mysql_query($query) or die(mysql_error());

From that, it should give you a mysql error, rather than a php error.

[echo]

It's likely to be the extra semicolon, change

$query="select * from user where name='$user' and password='$password';"; 

to

$query="select * from user where name='$user' and password='$password'"; 

[jael]

i've try to delete the";" but the same error appear:mad:

however i will try to include more catch error to display the mysql error....!

thans....thanks......!

[fuji]

Assuming that you've removed the semi-colon in the first $query variable, I would add this code block above line 11. Right after the mysql_query call and above the mysql_fetch_row() call.... i have this nagging feeling that your result holds no data...

if (mysql_num_rows($result) < 1)
{
	echo 'We cant fetch the row if we dont have a result <br />';
	echo 'here is our query'.$query;
	exit;
}

If this little if-statement fires, it will tell you that your result is not grabbing any info, and will echo out the $query var that holds your select statement. Look over that line and make sure all is well...

Hope this helps

[hand]

Originally posted by Kristopher

$result = mysql_query($query) or die(mysql_error());

From that, it should give you a mysql error, rather than a php error. [/B]

Please do this !!

header("Location: aullink.php?level=4"); // please without $
header("Location: aullink.php?level=3"); // please without $

The error Warning: Cannot add header information - headers already sent by ... occurs because of the warning Supplied argument is not a valid MySQL

[jael]

SO good that i've ound the bug....
the $result really hold no data coz i have typing error in the input parameter!

so sorry .....

but thanks a lot!

so tired!

[jael]

anyone can help me?

remember last time i said i can login...
but now i can't.......!

so i try to find the problem....

i add in the echo "result" to see if i got a result.!

mysql_connect($host,$user,$password);
mysql_select_db($database);
$query = stripSlashes($query);
$result = mysql_query($query);
echo "$result";
if ($row = mysql_fetch_array($result)){

and get this error..

Resource id #2
Warning: Cannot add header information - headers already sent by (output started at /home/clc/www/html/login.php:10) in /home/clc/www/html/login.php on line 23

did i really got a input result to fetch row...

i just don't know why!

[nhwaldron]

Found the problem