Posted by Jasper Bryant-Greene on 11/14/05 02:14

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

[Back to original message]