mysql_result()

[leequalls]

I have tried the followinf things in the code below and all of them give me an error

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource

 

What am I doing wrong?

 

$email = $_SESSION["sess_name"];

$res = mysql_query("SELECT * FROM members where email=$email");
$member1 = mysql_result($res, 0, "ref1"); 
$member2 = mysql_result(mysql_query("SELECT ref2 FROM members where email=$email"), 0); }

 

 

[Zeradin]

double post thing

[Zeradin]

 

shouldn't it be $res = mysql_query("SELECT * FROM members where email=".$email)

 

[revraz]

Put single quotes around '$email'

 

 

[leequalls]

 

shouldn't it be $res = mysql_query("SELECT * FROM members where email=".$email)

 

no that would be  $res = mysql_query("SELECT * FROM members where email=".$_SESSION["sess_name"]);

but I get the same error with this

[leequalls]

thanks revraz that worked