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:[EMAIL PROTECTED]
> Sent: Friday, February 28, 2003 7: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
