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: 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
