worked

Hey that worked guys.. Thanks..Dan You need to create a column in the target table similar to: custID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT When you run your INSERT query, you pass NULL to that column and the ID will be created/auto incremented for you. Is that what you mean? Rich

-----Original Message----- From: Dan Kelly [mailto:dk4210@planttel.net] Sent: Friday, February 28, 2003 7:52 PM To: php-db@lists.php.net 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