Re: please shed some light on SQLsyntax error

Bruce Gilbert wrote:

You would need to show us the SQL that was causing that error. Otherwise it is fairly meaningless.

hope this helps... <? //check for required form variables if ((!$_POST[f_name]) || (!$_POST[l_name])) {

Unrelated, but you should have quotes here. Like $_POST['f_name']

header("Location:http://www.inspired-evolution.com/show_addcontact.php");

There should also probably be a space between the : and the start of the URL here.

exit; }else { //if form variables are present,start a session session_start(); } //check for validity of user if ($_SESSION[valid] != "yes") {

Again, quotes on the array subscript.

header("Location:http://www.inspired-evolution.com/contact_menu.php");

And space between colon and URL here.

exit; } //set up table and database names $db_name ="bruceg_contactlist"; $table_name ="Contact List"; //connect to server and select database $connection = @mysql_connect("69.90.6.198","database_username","password") or die(mysql_error()); $db = @mysql_select_db($db_name,$connection) or die(mysql_error()); //build and issue query $sql = "INSERT INTO $table_name values ('', '$_POST[f_name]',

You'll be wanting to put backticks (`) around the table name, because it contains a space. Jasper