Hoes and Drugs

[montyash]

i tried to recruit hoes and it gave me this can any 1 help

You Lost 1 hookers

You Lost 1 prostitutesQUERY 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 '' at line 1

Query was UPDATE users SET prostitutes=prostitutes-1 WHERE userid=

[Akash]

Re: Hoes and Drugs

Erm it would help for us to see the exact query...e.g. what comes after `userid=`?

Is it something like:

$db->query("UPDATE `users` SET `prostitutes` = `prostitutes` - 1 WHERE `userid`= $userid");

:?

If so try replacing $userid with $ir['userid'] or if $userid isn't there, add that instead.

[HarryB]

Re: Hoes and Drugs

$db->query("UPDATE `users` SET prostitutes=prostitutes-1 WHERE `userid`= $userid");

That should work