php mySQL insertion issue

Question

Do you see something wrong in this insertion??

It does not work for me..

$insSubm = "INSERT INTO cR_Submissions memberID ='".$memberID."', RefNumb='".$RefNumb."', title ='".$title."', CopyRightNumb='".$copyRightNumbWork."', type='".$natureTypeWork."', OtherTitle='".$alternateTitleWork."', OwnershipTransfer='".$textareaPrior."', Status ='".$status."', DateWhen='".$todaydate."', Time='".$NowisTime."'";
$resultinsSubm=mysql_query($insSubm) or die("Error insert Submissions: ".mysql_error());

Am I blind?

Please help

Thanks

What's the mysql_error() returning? Also note you are using the alternate INSERT syntax, which may not be supported in your version. — Jason McCreary
– Jason McCreary, Commented Jun 4, 2011 at 15:09

rid · Accepted Answer · 2011-06-04 15:09:01Z

4

That's invalid SQL syntax. The SQL syntax is:

INSERT INTO table (field1, field2, ..., fieldN) VALUES (val1, val2, ..., valN)

An alternative MySQL syntax for this is:

INSERT INTO table SET field1 = val1, field2 = val2, ..., fieldN = valN

You're missing the SET keyword. Check out the INSERT Syntax documentation for more about this.

answered Jun 4, 2011 at 15:09

rid

64k31 gold badges159 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nick Pyett · Accepted Answer · 2011-06-04 15:11:06Z

0

Query should be something like...

$insSubm = "
  INSERT INTO `cR_Submissions` (`memberID`, ...)
  VALUES ('" . $memberID . "', ... )";

answered Jun 4, 2011 at 15:11

Nick Pyett

3,4181 gold badge26 silver badges27 bronze badges

Comments

Racooon · Accepted Answer · 2011-06-04 15:16:38Z

0

change your code with the following code:

$insSubm = "INSERT INTO cR_Submissions (memberID, RefNumb, title, CopyRightNumb, type, OtherTitle, OwnershipTransfer, Status, DateWhen, Time) 
            VALUES ('$memberID', '$RefNumb', '$title', '$copyRightNumbWork', '$natureTypeWork', '$alternateTitleWork', '$textareaPrior', '$status', '$todaydate', '$NowisTime');";

$resultinsSubm = mysql_query($insSubm) or die("Error insert Submissions: ".mysql_error());

answered Jun 4, 2011 at 15:16

Racooon

1,4962 gold badges10 silver badges29 bronze badges

Collectives™ on Stack Overflow

php mySQL insertion issue

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related