MySQL Help

[Razor42]

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')

[Seker]

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')

[Octarine]

Personally, I'd remove the comma immediately preceding the WHERE clause, but that's just me, I like my queries to work.

[Seker]

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

[Razor42]

Thanks guys thread can be closed now.