Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Max E.K
] Incrementing Primary Key At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites. Â The sites

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
/ Vienna Subject: Re: [PHP-DB] Incrementing Primary Key At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: [PHP-DB] Incrementing Primary Key At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
-lists.php.net php-db@lists.php.net Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: [PHP-DB] Incrementing Primary Key At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net

RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
: Re: [PHP-DB] Incrementing Primary Key At 01:17 PM 10/28/2010, Bastien Koert wrote: On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 03:40 AM 10/28/2010, Max E.K wrote: From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg

RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
-lists.php.net; rquadl...@googlemail.com Subject: Re: [PHP-DB] Incrementing Primary Key At 01:17 PM 10/28/2010, Bastien Koert wrote: On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 03:40 AM 10/28/2010, Max E.K wrote: From: Ethan Rosenberg eth...@earthlink.net

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
: Thursday, October 28, 2010 2:02 PM To: Bastien Koert Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com Subject: Re: [PHP-DB] Incrementing Primary Key At 01:17 PM 10/28/2010, Bastien Koert wrote: On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 03:40 AM

[PHP-DB] Incrementing Primary Key

2010-10-27 Thread Ethan Rosenberg
Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites. The sites will be identified by a letter {A,B,C }. The medical record number [primary key] will start at 1001 and increment by one(1) for each

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
I think having a table for each site would be sufficent -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Wednesday, October 27, 2010 9:11 AM To: php-db-lists.php.net Subject: [PHP-DB] Incrementing Primary Key Dear List - Thanks for all your excellent help

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
Just set the primary key to AUTO_INCREMENT on each field and you won't have to worry about it -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Wednesday, October 27, 2010 9:11 AM To: php-db-lists.php.net Subject: [PHP-DB] Incrementing Primary Key Dear List

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Andrés G . Montañez
Hi Ethan, in this case, you should manage the keys by your application, and store the used ids in aonther table, similar to a sequence in Oracle or Postgresql. Thats so if you want all the records un one table (a field for the letter, and the other for the numeric part). Otherwise, having a table

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
] Incrementing Primary Key Hi Ethan, in this case, you should manage the keys by your application, and store the used ids in aonther table, similar to a sequence in Oracle or Postgresql. Thats so if you want all the records un one table (a field for the letter, and the other for the numeric part

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Max E.K
: Wednesday, October 27, 2010 3:11:00 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: [PHP-DB] Incrementing Primary Key Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites. The sites

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Andrés G . Montañez
- From: Andrés G. Montañez [mailto:andresmonta...@gmail.com] Sent: Wednesday, October 27, 2010 9:19 AM To: Ethan Rosenberg Cc: php-db-lists.php.net Subject: Re: [PHP-DB] Incrementing Primary Key Hi Ethan, in this case, you should manage the keys by your application, and store the used ids

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Richard Quadling
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites.  The sites will be identified by a letter {A,B,C }.  The medical record number

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Max E.K
] Incrementing Primary Key On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites.  The sites will be identified by a letter {A,B,C

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Ethan Rosenberg
At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites. Â The sites will be identified