SQL INSERT INTO problem

nylex

Hi, I wrote a script to add info to an Access database via a form. When the page is loaded, I get the following error message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\nc\test1.php on line 23

Help!! Here is my code:

<body>

Name: <input type="text" name="Name"><br>
Age: <input type="text" maxlength="2" name="Age"><br>
Location: <input type="text" name="Location"><br>
Email: <input type="text" name="Email"><br>

<?
$Connect = odbc_connect("News", "NC", "TEST");

$Query = "INSERT INTO Test (Name, Age, Location, Email) VALUES ('$Name', $Age, '$Location', '$Email')";

if(!(odbc_exec($Connect, $Query)))
{
	print('Info could not be added to database');
}

</body>

What is wrong with it? Any help appreciated, thanks.

crusty_php

It's probably because when your script first runs the insert statement has no values! Make it dependant upon a value being set to do the insert:

IF (isset($_POST["Name"]}}{
//do your insert
}

daynah

Yea, Martin is right. You're not inserting any values into the INSERT statement. Here is how you would do it.

if($Submit)
{
$Connect = odbc_connect("News", "NC", "TEST");

$Query = "INSERT INTO Test (Name, Age, Location, Email) VALUES ('$Name', $Age, '$Location', '$Email')";

if(!(odbc_exec($Connect, $Query)))
{
print('Info could not be added to database');
}
}
?>

I put if $Submit because you want to check when the form is filled out and is submitted before trying to insert anything. Hope that helps. 🙂

nylex

Rofl, I'm such a newbie at PHP. Thanx both of you 🙂.