mySQL update?

[RON_ron]

my code with the problem:

 

$res = sprintf("UPDATE student SET Pas = '%s' WHERE Mail = '%s'", mysql_real_escape_string($Ber), mysql_real_escape_string($Mail));

$resDone = mysql_query($res);

 

I can not get this work? I don't see any mistake in this code?? Could someone please help...

I tried echo ($res)... it was blank? (I can assure the variable names are correct)

[darkfreaks]

could be a mysql syntax error try this and tell me what you get.....

 

$resDone = mysql_query($res) or die(mysql_error());

 

[RON_ron]

Thanks for the reply darkfreaks.

 

it's blank.

[scootstah]

Thanks for the reply darkfreaks.

 

it's blank.

 

There is no syntax error in that line, and the code works fine for me.

 

Post your whole code please.

[RON_ron]

$query3 =sprintf("SELECT * FROM student WHERE Mail ='%s' AND Usr = '1'", mysql_real_escape_string($Mail));
$query3a = mysql_query($query3);
if(mysql_num_rows($query3a) > 0){
$res = sprintf("UPDATE student SET Pas = '%s' WHERE Mail = '%s'", mysql_real_escape_string($Ber), mysql_real_escape_string($Mail));
$resDone = mysql_query($res);
}

[scootstah]

if(mysql_num_rows($query3a) > 0){

 

Are you sure that statement is true?

[RON_ron]

of course it's correct.