Chief Delphi - ODBC SQL Problem

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)

- Website Design/Showcase (http://www.chiefdelphi.com/forums/forumdisplay.php?f=64)

- - ODBC SQL Problem (http://www.chiefdelphi.com/forums/showthread.php?t=29135)

ODBC SQL Problem

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.

Re: ODBC SQL Problem

Ok, I have figured it out, with the help of my dad.

I didn't include single-quotes ( this ' ) around the varibles that might have spaces in it.

Example:

PHP Code:


		
			
$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 . "')";

PHP Code:


		
			
$Address_TextBox

would not work, but

PHP Code:


		
			
$rest_of_sql1 . ", '" . $Address_TextBox . "', " . $rest_of_sql2

would.

I hope this helps somebody.