[PHP-DB] Customer id

[Dan Kelly]

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