RE: [PHP-DB] Customer id
| From: | Hutchins, Richard | Date: | Fri, 28 Feb 2003 21:44:30 +0000 |
| Subject: | RE: [PHP-DB] Customer id | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26018@lists.php.net to get a copy of this message | ||
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
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>