HI guys
i really need some help can anyone tell me whats wrong with the code below, it can connect to the database but not insert customer
================================
<html>
<head>
<title>Scotia Cruises registration</title>
</head>
<body>
<h1>Member Registration</h1>
<?php
/* example line below should be
$FirstName = $_POST['customer_forename'];
*/
$Title = $_POST['customer_title'];
$FirstName = $_POST['customer_forename'];
$SecondName = $_POST['customer_surname'];
$AddressLine1 = $_POST['customer_address_1'];
$AddressLine2 = $_POST['customer_address_2'];
$Town = $_POST['customer_town'];
$Postcode = $_POST['customer_postcode'];
$Age = $_POST['customer_age'];
$Country = $_POST['customer_country'];
$TelephoneNumber = $_POST['customer_telephone_number'];
$Email = $_POST['customer_email'];
$Password = $_POST['customer_password'];
@ $db = mysql_connect('sql.comp-degree.uhi.ac.uk', '*********', '*********');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
else
{
mysql_select_db('Siddique');
/* query values should be $title, $FirstName, $SecondName etc
so for example:
insert into 'customer'('customer_title','customer_forename') values ($title,$FirstName)
*/
$query = "insert into customer('customer_title','customer_forename','customer_surname','customer_address_1','customer_addr ess_2','customer_town','customer_postcode','customer_age','customer_country','customer_telephone_num ber','customer_email','customer_password','userlevel') values ($customer_title,$customer_forename,$customer_surname,$customer_address_1,$customer_address_2,$custo mer_town,$customer_postcode,$customer_age,$customer_country,$customer_telephone_number,$customer_ema il,$customer_password,user)";
$result = mysql_query($query);
if ($result)
echo 'Member inserted';
else
echo 'Did not work';
}
?>
<p>Click <a href="Manage_account.html">here</a> to return to the login page</font></p>
</body>
</html>
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
