[RESOLVED] Submitting data to a basic form

[Lucky_Day]

I am learning PHP/MySQL using "..for Dummies" book and the author seems to lose me in certain examples.

<?php
  require("access.php");
  $connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
  $db = mysql_select_db($database,$connection)
       or die ("Couldn't select database");
  $query = "INSERT INTO customers(Name,Address,Address2,City,Zip,Phone,Fax)
            VALUES ('$cusName','$cusAddress','$cusAddress2','$cusCity','$cusZip','$cusPhone','$cusFax')";
  $result = mysql_query($query)
       or die ("Couldn't execute query.");
  $customerid = mysql_insert_id();
?>

I basically want to submit basic data to the database. My ERROR is "couldn't execute query".

I have checked it and checked it again. . .can anyone help

Thanks for reading this far. . .

Lucky

[jeepin81]

see if this helps.

<?php 
require("access.php"); 
$connection = mysql_connect($host,$user,$password) 
or die (mysql_error()); 
$db = mysql_select_db($database,$connection) 
or die (mysql_error()); 
$query = "INSERT INTO customers(Name,Address,Address2,City,Zip,Phone,Fax) 
VALUES ('$cusName','$cusAddress','$cusAddress2','$cusCity','$cusZip','$cusPhone','$cusFax')"; 
$result = mysql_query($query, $connection) 
or die (mysql_error()); 
$customerid = mysql_insert_id(); 
?>  

Best.
J.

[Lucky_Day]

That worked great!

Thanks alot