Re: [PHP] I want to AUTO_INCREMENT fields

2001-07-27 Thread elias

yes, sort of...
both have same number.

Alexander Skwar [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
So sprach »elias« am 2001-07-26 um 11:23:56 +0200 :
 first field is the primary key and is called 'id' and is an integer,
 and i want another field of type integer to be also autoincremented...

Pardon me - but what would be the use??   Both columns would contain the
same numbers, no?

Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 3 days 18 hours 13 minutes



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] I want to AUTO_INCREMENT fields

2001-07-26 Thread David Robley

On Thu, 26 Jul 2001 18:53, elias wrote:
 Hi!

 I want to have to fields,
 first field is the primary key and is called 'id' and is an integer,
 and i want another field of type integer to be also autoincremented...

If you are using mysql, this snippet from the manual answers your 
question:

NOTE: There can be only one AUTO_INCREMENT column per table, and it must 
be indexed.

-- 
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA  

   Don't play stupid with me! I'm better at it.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] I want to AUTO_INCREMENT fields

2001-07-26 Thread Alexander Skwar

So sprach »elias« am 2001-07-26 um 11:23:56 +0200 :
 first field is the primary key and is called 'id' and is an integer,
 and i want another field of type integer to be also autoincremented...

Pardon me - but what would be the use??   Both columns would contain the
same numbers, no?

Alexander Skwar
-- 
How to quote:   http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:   http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 3 days 18 hours 13 minutes

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]