Bruce Gilbert wrote:
for the table name you mean like this?
$table_name =" 'Contact List' ";
No, backticks. I gave an example of the backtick in my email (in
brackets). It is on the same key as the tilde, and looks like this: `
Also, I would probably left $table_name as it was and put the backticks
in the SQL statement, like this:
$sql = "INSERT INTO `$table_name` values ('', '$_POST[f_name]', [...]
Jasper
On 11/13/05, Jasper Bryant-Greene <jasper@xxxxxxxxxxx> wrote:
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
--
::Bruce::
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
