error

adiwood

I have done the changes and still have errors. It is coming up with Error adding submitted details: Query was empty and ot showing anything else. what is wrong.

Below is my code:

<html>
<head>
<title> Customer Details </title>
</head>

<body>

<?php
if (isset($_POST['addcustomer']))
{
?>

<form action=<?=$_SERVER['PHP_SELF']?> "method="post">
<p>Please enter your details <br>

FirstName: <input type="text" name="FirstName" /> <br>
LastName: <input type="text" name="LastName" /> <br>

<input type="hidden" name="submitcustomer" value="true" />
<input type="submit" value="SUBMIT">
</p>
</form>



<?php
}
else

$dbcnx = @mysql_connect('localhost', 'root', '');

if (!$dbcnx) 
{
	die( '<p>Sorry Fernbarrrow website is experiencing difficuties at current.</p>');
}

if (! @mysql_select_db('customerdetails' ) )
{
	die  ( '<p>Sorry Fernbarrrow website is experiencing difficuties at current.</p>');
}

if (isset($_POST['submitcustomer'])) 
{
$FirstName = $_POST['FirstName'];
$sql = "INSERT INTO customerdetails VALUES
CustomerID='$customerid";
}
if (@mysql_query($sql))
{
echo('<p>Your details have been added.</p>');
} else {
echo('<p>Error adding submitted details: ' .
mysql_error() . '</p>');
}


?>
</body>
</html>

thespear

change

<form action=<?=$_SERVER['PHP_SELF']?> "method="post">

<?php echo "<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">"; ?>

TomD

Try changing:

<form action=<?=$_SERVER['PHP_SELF']?> "method="post">

<form action="<?PHP echo $_SERVER['PHP_SELF']; ?>" method="post">

or even

<form action="" method="post">

adiwood

all of them didnt work

thespear

<?php
}
else

needs a {

adiwood

no still not working!

helz

like thespear said im surprised that you did not get a parse error for that reason,
after the last if else echo out $sql to see whats happening
also if its displaying: error adding submitted details
what is the sql error thats being outputted?

adiwood

what do i have to do?

It is displaying nothing now - after adding all th3 stuff people said!

helz

at the bottom of your code put:
echo $sql;

where you wrote: mysql_error() an error should be displayed apart from: error adding submitted details