connecting to MySQL database through php

Sean2004

Hi,
Im trying to write information from an on-line form to a mysql database using php. I am trying to write to a customer table, which references an addresses table and a credit card table.

$titl=$_POST["title"];
$fname=$_POST["firstname"];
$sname=$_POST["surname"];
$addr=$_POST["address"];
$twn=$_POST["town"];
$cty=$_POST["city"];
$pcode=$_POST["postalcode"];
$ctry=$_POST["country"];
$phone=$_POST["telephone"];
$mail=$_POST["email"];
$ctyp=$_POST["cardType"];
$cnum=$_POST["cardNumber"];
$expmonth=$_POST["cardMonth"];
$expyear=$_POST["cardYear"];

I am able to write the above information to one big table: EG:

$db->query("INSERT INTO Customer(title, firstname, surname, address, town, city, postalcode, country, telephone, email, cardType, cardNumber, cardMonth, cardYear)
VALUES('$titl', '$fname','$sname', '$addr', '$twn', '$cty', '$pcode', '$ctry', '$phone', '$mail', '$ctyp', '$cnum', '$expmonth', '$expyear')");

but am wondering what syntax is used to write to serveral tables using referencing?
Thanks fro the help!

Caixa

Probably a stupid question, but did you make sure that you changed these variables to the correct values?
[php]
define("EZSQL_DB_USER", ""); // <-- mysql db user
define("EZSQL_DB_PASSWORD", "*******"); // <-- mysql db password
define("EZSQL_DB_NAME", "*******"); // <-- mysql db pname
define("EZSQL_DB_HOST", "localhost"); // <-- mysql server host[/php]

Sean2004

@Caixa
Thanks fro the help yesterday, was a silly problem which I figured out in the end

satchmo

If you post up a question and then figure out the answer yourself, you should post that up too in case anyone else comes looking with the same problem!

Sean2004

Ok. There was a problem with the host so it wasnt on my part.