RE: [PHP-DB] mysql ID's
| From: | Dave Watkinson | Date: | Mon, 15 Oct 2001 13:21:12 +0000 |
| Subject: | RE: [PHP-DB] mysql ID's | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13326@lists.php.net to get a copy of this message | ||
if you use an auto_increment column type a new number will be created
for all new records. I don't think there's an auto_incrementing
alphanumberic column type - you'd have to do it with code
hth
Dave
-----Original Message-----
From: Adam Jackson [mailto:adam@weblinx.com.au]
Sent: 15 October 2001 14:27
To: php-db@lists.php.net
Subject: [PHP-DB] mysql ID's
i dont know if this should be posted here or a mysql list but its worth
a
try..
I am trying to make it so that when i create a row with user details one
of
the columns is automatically generated with the next id. for example
p00001,
p00002 etc etc. I am fairly new to PHP, MySQL so bare with me :)
any assistance is greatly appreciated.
-Adam