Well, I started creating a test program that enters data from a HTML table to a database.
I wrote this code, but I keep getting this error:
Quote:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\ibserver\www\ucs\create_user.php on line 22
Error in SQL
|
I can't seem to figure out the problem. I know I have everything setup correctly, and I don't understand why it's not working.
PHP Code:
<?php
//Include Config Information
require("config.php");
//Connect to Database
$conn=odbc_connect($dbname,$dbuser,$dbpass);
//If Connection Failed, Show Error Message
if (!$conn)
{
exit("Connection Failed: " . $conn);
}
//Insert Data into Database
$sql="INSERT INTO Sellers (Username, Password, LastName, FirstName, Address, City, State, ZIP, Phone, EMail) VALUES ($UserName_TextBox, $Password_TextBox, $LastName_TextBox, $FirstName_TextBox, $Address_TextBox, $City_TextBox, $State_TextBox, $ZIP_TextBox, $Phone_TextBox, $EMail_TextBox)";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{
exit("Error in SQL");
}
odbc_close($conn);
echo "Sucessful!";
?>
Note: I am using ODBC instead of MySQL since I am developing this for a server without MySQL.