Syntax help wanted...

[yonnieb]

Hey Guys...

 

This is my query into a database.... the values are all empty in this statement. For example, this query:

 

$odbcquery = "INSERT INTO Holdings VALUES ( '$holding' ,'$SIN','$SetupDate','$lastname','$firstname',

              '$streetaddress','$city','$province','$country','$postalcode','$fundname','$fundclass','$plantype',

      '$unitsheld','$inceptiondate','$marketvalue','$fundcodeandload')";

 

 

Prints out this:

 

 

INSERT INTO QuadrusHoldings VALUES ( '' ,'','','','', '','','','','','','','', '','','','')

 

 

I am using the exact same syntax in a mysql database in another program and it works fine. Not quite sure what the problem is...

 

Thanks a bunch for your time.

 

YB

 

[cooldude832]

You can't just say insert values you have to gives fields to insert to (generally speakign) secondly are you even suer those vars are declared on the page>

[yonnieb]

This code inserts blank values into the first record of the database... so the sql is correct.

The problem is that there are duplicate values (or blanks in my case) in the primary key. This is the error message:

 

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again"

 

 

 

To answer your question, yes the variables are declared, and they also print to screen right (with an echo statement) before the SQL statement.

[cooldude832]

declare fields in the query (sounds like a pain, but it will help it probably) and make your primary key auto increment