Hi,
I looked through these forums and I followed the recommendations and advice given about inserting data into a MySQL database from a PHP form. However when I tried it, I couldn't get it to work.
Here's the script:
Form.php:
<form action="process.php" method="post" name="maillist">
<input type="text" name="firstname">
<input type="text" name="lastname">
<input type="text" name="email">
<input type="submit" name="Submit" value="Join">
<input type="reset" name="reset" value="Clear">
</form>

Process.php
<?php

$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];

$dbh=mysql_connect ("localhost", "****", "****") or die ('Cannot connect to Database - error: ' . mysql_error () );
mysql_select_db("****",$dbh);
$sql = "INSERT INTO `list` ('id', 'firstname', 'lastname', 'email') VALUES ('', '$firstname', '$lastname', '$email');";
mysql_query($sql);
?>

"id" is used as an increment

When the user clicks the "Join" button the data does not go into the database. What am I doing wrong?
Kevin