INSERT INTO won't work

[Nuv]

I don't understand why won't my INSERT work. Nothing gets inputted to the database.Why ?

Code

 $sql = "INSERT INTO payout (member_id, binary, tds, service, total, dues, amount_paid) VALUES ('".$memid."', '".$binary."', '".$tds."', '".$service."', '".$total."', '".$dues."', '".$amount_paid."')";
     $execsql = mysql_query($sql);

 

SQL table

CREATE TABLE IF NOT EXISTS `payout` (
  `member_id` int( NOT NULL,
  `binary` int(10) NOT NULL,
  `tds` decimal(7,2) NOT NULL,
  `service` decimal(7,2) NOT NULL,
  `total` int(10) NOT NULL,
  `dues` int(10) NOT NULL,
  `amount_paid` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[Zane]

I don't understand why won't my INSERT work. Nothing gets inputted to the database.Why ?

This is exactly why PHP.net created the mysql_error function... and you can either use die to show it or just echo it out.

$execsql = mysql_query($sql) or die(mysql_error());

[spiderwell]

echo out the sql statement in the php script to see acopy of exactly what it is that the insert is actually tryin to insert. that should help a lot

[Nuv]

 

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 'binary, tds, service, total, dues, amount_paid) VALUES ('1000000', '200', '10.6'' at line 1

 

Echo of sql statement

INSERT INTO payout (member_id, binary, tds, service, total, dues, amount_paid) VALUES ('1000000', '200', '10.6', '20.4', '170', '0', '170')

 

[Zane]

perhaps one of your field names are reserved words.  Try surrounding them in backticks

INSERT INTO payout (`member_id`, `binary`, `tds`, `service`, `total`, `dues`, `amount_paid`) VALUES ('1000000', '200', '10.6', '20.4', '170', '0', '170')

[Nuv]

Wow Thankyou.That worked. Many of my sql statements arent working. Can i use ` in everyone of them ?

[spiderwell]

its better to do it with them than without, cuz lets face it, you wouldnt have posted this thread if ya had 

 

backticks for table names and column names, and single quotes for the data, then you won't fall over with column names that are reserved words

 

[Nuv]

Ah alright. Thankyou