Why isn't this inserting?

[philvia]

i'm sure it's quite easy to find but... i cant >_<
it displays the 'sucess' message but it doesn't insert into the database....

if ($_POST['buy']) {
$sql="UPDATE `users` SET `banked` = `banked` - 5 WHERE `userid` = '".$user."'";
$result=mysql_query($sql);
$sql="INSERT INTO `lotto` (null, user, null, null)VALUES(null, '$user', null, null)";
$result=mysql_query($sql);

[HalfaBee]

put

or die( mysql_error()." in sql $sql" );

after the mysql_query() and you may reveal the problem.

HalfaBee

[Weedpacket]

INSERT into a "null" column? Can you do that?

[jimson]

$sql="UPDATE `users` SET `banked` = `banked` - 5 WHERE `userid` = '".$user."'";

// or can change it to

$banked = $banked - 5;
$sql="UPDATE users SET banked = '$banked' WHERE userid= '$user' ";

null, user, null, null

this mean you have 3 column with same name named null?
please desc your table. i am sure that SQL statement is wrong.

[HalfaBee]

Dohh.
Why do you think I suggested the debug statements.

I am sure the mysql_error() would have pointed out the problem.

Debugging seems to be a lacking skill in most posts.

HalfaBee

[philvia]

the null,user,null,null was something a friend of mine suggested doing...

[seby]

lol well your friend has no idea that you can't have multiple columns with the same name, especially nulls 😃

[jimson]

u can't have multiple columns with same name.