Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
gt; Sent: 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 > w

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 wrote: > > At 03:40 AM 10/28/2010, Max E.K wrote: > > > >> From: "Ethan Rosenberg"

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 wrote: > > At 03:40 AM 10/28/2010, Max E.K wrote: > > > >> From: "Ethan Rosenberg" > >> To: rquadl...@googlemail.com

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
hp.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

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
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 wrote: >> > > D

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
At 03:40 AM 10/28/2010, Max E.K wrote: From: "Ethan Rosenberg" To: rquadl...@googlemail.com, "Ethan Rosenberg" Cc: "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:

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Max E.K
From: "Ethan Rosenberg" To: rquadl...@googlemail.com, "Ethan Rosenberg" Cc: "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 A

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 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

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Max E.K
- Original Message - From: "Richard Quadling" To: "Ethan Rosenberg" Cc: "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] Incrementing Primary Key O

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Richard Quadling
On 27 October 2010 14:11, Ethan Rosenberg 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 [primary key]

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Andrés G . Montañez
riginal 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] Incrementing Primary Key > > Hi Ethan, > in this case, you should manage th

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 Jimmy Sole
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 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 ta

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 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. I