What is wrong with this queue?

[d00dle]

I know it's wrong somewhere but I'm not sure where...
it subtracts but it doesn't umm.. do anything else o_o.

if ($_POST['buy']) {
if ((5 <= 0) || (5 > $me['aura'])) {
echo "<tr><td colspan=2 class=sys align=center>You don't have enough $aura to purchase a ticket.</td></tr>";
} else {
mysql_query('UPDATE `users` SET `aura` = `aura` - 5 WHERE `username` = $uname');
mysql_query('INSERT INTO `lotto` (`username`) VALUES ("'.$uname.'")');
mysql_query('UPDATE `lotto` SET `prize` = `prize` + 5 WHERE `id` = 1');
echo "<tr><td align=center colspan=2 class=sys>Your ticket has been purchased, you can buy more if you like, GOOD LUCK!</td></tr>";
} }

[leatherback]

Hi,
remove the quotes around the colum names, and that should helpa lot.
Of course you know that 5 is never smaller then 0??

J

[swr]

Originally posted by d00dle
I know it's wrong somewhere but I'm not sure where...
it subtracts but it doesn't umm.. do anything else o_o.

mysql_query('INSERT INTO `lotto` (`username`) VALUES ("'.$uname.'")');

[/B]

It looks like you're enclosing the string (in the resulting SQL) in double quotes. I can't remember if MySQL accepts that or not; I always use single quotes.

From what you describe, the first SQL statement is executing, but the others aren't. My guess is there is something wrong with the SQL statements themselves. Either MySQL doesn't like the double quotes as I've suggested, or something else.

Any time you do "mysql_query($query);" you should instead be doing "mysql_query($query) or die(mysql_error());". ALWAYS. That way when something goes wrong you'll get an error message telling you exactly what went wrong where, instead of letting the script think everything is fine leaving you scratching your head. A little bit of error checking can save hours of debugging.