MySQL database not updating from php code

[tjverge]

the below code as I understand should insert a new record into my database, but it's not.

 

<?php
$notes = $_POST['notes'];
$cnamedb = $_POST['cname'];
$username = $_SESSION['username'];

mysql_query("INSERT INTO `ccccomma_eve`.`corps` (`id`, `name`, `ticker`, `alliance`, `ceo`, `tax`, `members`, `hq`, `apidate`, `notes`, `notedate`, `updatedby`) VALUES ('', '$cnamedb', '', '', '', '', '', '', '', '$notes', NOW(), '$username'");

echo $cnamedb." Updated";
?>

 

Any ideas why?

[tjverge]

updated to this so I could see the error:

<?php
$notes = $_POST['notes'];
$cnamedb = $_POST['cname'];
$username = $_SESSION['username'];

$query ="INSERT INTO `ccccomma_eve`.`corps` (`id`, `name`, `ticker`, `alliance`, `ceo`, `tax`, `members`, `hq`, `apidate`, `notes`, `notedate`, `updatedby`) VALUES ('', '$cnamedb', '', '', '', '', '', '', '', '$notes', NOW(), '$username'";

mysql_query($query) or die('mysql error ' . mysql_error() . ' in query : ' . $query);

echo $cnamedb." Updated";
?>

this is the out put:

 

mysql 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 in query : INSERT INTO `ccccomma_eve`.`corps` (`id`, `name`, `ticker`, `alliance`, `ceo`, `tax`, `members`, `hq`, `apidate`, `notes`, `notedate`, `updatedby`) VALUES ('', 'The Choireporation', '', '', '', '', '', '', '', 'test', NOW(), 'TX1'

[taquitosensei]

You left off the closing parenthesis on your values.

[tjverge]

Sorry I don't see it they all look like they have a matching open and close... could you please post the right code?

 

Thank you

[tjverge]

Sorry I don't see it they all look like they have a matching open and close... could you please post the right code?

 

Thank you

 

Still didn't work here is what I have:

 

$query ="INSERT INTO Corps (`id`, `name`, `ticker`, `alliance`, `ceo`, `tax`, `members`, `hq`, `apidate`, `notes`, `notedate`, `updatedby`) VALUES ('', '$cnamedb', '', '', '', '', '', '', '', '$notes', NOW(), '$username')";

[kenrbnsn]

What's the error you're getting now?

 

Ken

[tjverge]

It's fixed was a spelling error in my table name had Corps should of been corps

 

Thank you everyone for there help, and putting up with my questions