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

Reply via email to