Posted by Bruce Gilbert on 11/14/05 02:25

for the table name you mean like this?

$table_name =" 'Contact List' ";

On 11/13/05, Jasper Bryant-Greene <jasper@album.co.nz> 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::

[Back to original message]