zgkhoo Posted November 5, 2007 Share Posted November 5, 2007 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????? ??? Link to comment https://forums.phpfreaks.com/topic/76056-mysql-error/ Share on other sites More sharing options...
pocobueno1388 Posted November 5, 2007 Share Posted November 5, 2007 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()); ?> Link to comment https://forums.phpfreaks.com/topic/76056-mysql-error/#findComment-385047 Share on other sites More sharing options...
fenway Posted November 5, 2007 Share Posted November 5, 2007 where is the error????? ??? The error is that you're not showing us the query. Link to comment https://forums.phpfreaks.com/topic/76056-mysql-error/#findComment-385147 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.