Customers

[adiwood]

I have a customer database and the html of the form , however im a little unsure on how to get the data that has been added to the form to be added to the database and then show it on the next page.
I also have username and password in that form however i need to add them to a different table named user, and also add the custer id to this. How do i do it, or shall i jus have the user name and password in the customer details table.

[planetsim]

You will need to relate the user with the customer.

mysql_query("INSERT INTO users (id, username, password) VALUES('null','".$_POST['username']."', '".md5($_POST['password'])."')");

//md5() will than be used to check that the password is correct when they login

$userid = mysql_insert_id(); //gets the users id

//customers table

mysql_query("INSERT INTO customers (custid, userid, name, email) VALUES('null','".$userid."','".$_POST['name']."','".$_POST['email']."')");

//display it all on the page
echo "Username: ".$_POST['username']."<br />"Name: ".$_POST['name']."<br />"Email: ".$_POST['email'];

//dont display password for privacy reasons

Hope that helps