mysql error

[zgkhoo]

Error msg occur:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' WHERE Serialnum = 'ZZZ0041'' at line 1

 

 

mysql_query("UPDATE gamecard SET `Ownerid`= '$login',Upline='{$row2['Serialnum']}'}' WHERE Serialnum = '$row[serialnum]'") or die(mysql_error());
mysql_query("UPDATE gamecard SET Downleft='{$row['Serialnum']}' WHERE Serialnum = '$row2[serialnum]'") or die(mysql_error());

 

where is the error????? ???

[pocobueno1388]

Try this

 

<?php

mysql_query("UPDATE gamecard SET `Ownerid`= '$login',Upline='{$row2['Serialnum']}' 
WHERE Serialnum = '{$row['Serialnum']}'") or die(mysql_error());

mysql_query("UPDATE gamecard SET Downleft='{$row['Serialnum']}' WHERE Serialnum = '{$row2['Serialnum']}'") 
or die(mysql_error());

?>

[fenway]

where is the error????? ???

The error is that you're not showing us the query.