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????? ??? Quote 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()); ?> Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/76056-mysql-error/#findComment-385147 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.