Razor42 Posted August 21, 2012 Share Posted August 21, 2012 Would be greatful if someone could help me out with this. My query: $db->query(sprintf("UPDATE `users` SET `money` = `money` - '%d', `investPROFIT` = '%d', `investSTART` = unix_timestamp(), `investLENGTH` = '%d', `investDAYS` = '%d', WHERE `userid` = ('%u')", $_POST['invest'], $profit, $investtime,$timeuni, $userid)); Error: QUERY ERROR: 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 `userid` = ('1')' at line 6 Query was UPDATE `users` SET `money` = `money` - '40', `investPROFIT` = '0', `investSTART` = unix_timestamp(), `investLENGTH` = '0', `investDAYS` = '0', WHERE `userid` = ('1') Quote Link to comment Share on other sites More sharing options...
Seker Posted August 21, 2012 Share Posted August 21, 2012 Change : WHERE `userid` = ('%u')", To: WHERE (`userid` = %u)" , Error: QUERY ERROR: 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 `userid` = ('1')' at line 6 Query was UPDATE `users` SET `money` = `money` - '40', `investPROFIT` = '0', `investSTART` = unix_timestamp(), `investLENGTH` = '0', `investDAYS` = '0', WHERE `userid` = ('1') Quote Link to comment Share on other sites More sharing options...
Octarine Posted August 21, 2012 Share Posted August 21, 2012 Personally, I'd remove the comma immediately preceding the WHERE clause, but that's just me, I like my queries to work. Quote Link to comment Share on other sites More sharing options...
Seker Posted August 21, 2012 Share Posted August 21, 2012 Personally, I'd remove the comma immediately preceding the WHERE clause, but that's just me, I like my queries to work. Didn't even see that. Yeah, that would likely fix you right up. Hah Quote Link to comment Share on other sites More sharing options...
Razor42 Posted August 27, 2012 Author Share Posted August 27, 2012 Thanks guys thread can be closed now. Quote Link to comment 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.