Create a customer_id field in the database, make it primary, int, and autoincrement
---> Jonathan -----Original Message----- From: Dan Kelly [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 6:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Customer id How do I write a script that will automatically create an ID in the database. Here is a sample -------------------------- orderform.shtml ---------------------------------------- <form action="order.php" method="post"> First Name<input type="text" name="fname"><br> Last Name<input type="text" name="lname"> <input type="submit" name="submit" value="enter"> <input type="reset" name="Clear"> ------------------Order.php ---------------------------------------------------------- <?PHP include('dbconnect.php'); if ($submit == "enter") { $query = "insert into orders (fname,lname) values ('$fname','$lname')" ; mysql_query($query) or die (mysql_error()); } ?> Any Ideas? Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
