Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Leif K-Brooks
Stan Lemon wrote: Also, I believe in addition to AUTO_INCREMENT it has to be UNIQUE as well. Please correct me if I am wrong. No, just INDEX. UNIQUE will work fine, but I reccomend making it PRIMARY. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to de

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Stan Lemon
You're not planning on using DB for the autoincrementing are you? Just stray mysql functions? Also, I believe in addition to AUTO_INCREMENT it has to be UNIQUE as well. Please correct me if I am wrong. - Stan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread dpgirago
Tris, make the the field, id_number, an auto_increment field. [EMAIL PROTECTED] on 07/09/2003 07:44:34 AM To: [EMAIL PROTECTED] cc:(bcc: David P. Giragosian/MDACC) Subject: [PHP-DB] Auto inc in MySQL I know I'll get flamed for askign such a simple question, but here

RE: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Rich Hutchins
3 8:45 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Auto inc in MySQL I know I'll get flamed for askign such a simple question, but here goes... I have a MySQL DB and wanna increment a field 'id_number' by one each time, to avoid creating duplicates... I've done it before, bu

[PHP-DB] Auto inc in MySQL

2003-07-09 Thread Tristan . Pretty
I know I'll get flamed for askign such a simple question, but here goes... I have a MySQL DB and wanna increment a field 'id_number' by one each time, to avoid creating duplicates... I've done it before, but can't remember how... Any ideas? Tris... **