Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Max E.K
From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net Cc: php-db-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

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

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
for PHP every time you want to use a different database. I use the PDO mysql adapter, what do you use? -Original Message- 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

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Max E.K
Hi Ethan, I am working currently as clinical developer and have developed multi site databases for clinical trials. I would say the approach you take will depend on number of factors. How is the site connectivity? I had a scenario where sites had erratic and slow connectivity so i had to

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
- Original Message - From: Richard Quadling rquadl...@gmail.com To: Ethan Rosenberg eth...@earthlink.net Cc: php-db-lists.php.net php-db@lists.php.net Sent: Wednesday, October 27, 2010 4:10:52 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: [PHP-DB

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