MySQL Database || Tables Issue

Posted by user1780103 on Stack Overflow See other posts from Stack Overflow or by user1780103
Published on 2012-10-28T10:44:45Z Indexed on 2012/10/28 11:00 UTC
Read the original article Hit count: 136

Filed under:

I'm trying to write up a script where the user is able to purchase an amount of points for dollars. I want the transaction to be inserted into MySQL. I keep facing a: "Column count doesn't match value count at row 1" error. And I have no idea what I'm doing wrong.

I have written up this:

mysql_query("INSERT INTO paypal_donations VALUES (NULL, ".$account_id.", ".$char_id.", ".$price.", ".$dp.", NOW(), NOW(), 'Started', 0, 0, '', '');") or die(mysql_error());

But I don't know what to execute in MySQL, since I've never worked with it before.

Could anyone write up a quick script that I can insert into MySQL for it to work.

© Stack Overflow or respective owner

Related posts about mysql