Re: [PHP] Inserting into multiple tables

2010-04-12 Thread Gary
Tedd Thanks for your response, perhaps I was completely missing this or my powers of expanation have gone out the window. I have found a solution and I am going to put it in its own post. Thanks again. gary "tedd" wrote in message news:p0624080ac7e9123f4...@[192.168.1.102]... > At 11:05 AM

Re: [PHP] Inserting into multiple tables

2010-04-12 Thread tedd
At 11:05 AM -0400 4/12/10, Gary wrote: -snip- If normalization is so important, why is it that the INSERT INTO multiple tables is not a standard command or procedure?. In my view, you are mixing apples and oranges. "Normalization" is simply cutting down on repetition. Inserting data into mult

Re: [PHP] Inserting into multiple tables

2010-04-12 Thread Gary
Nathan Thank you for your excellent explanation! One of the reasons I love this board is the vast knowledge that people are willing to share. I believe I understand the importance of normalization, however one of my original questions seems to still stand. If normalization is so important, why

Re: [PHP] Inserting into multiple tables

2010-04-11 Thread Paul M Foster
On Sun, Apr 11, 2010 at 12:21:28AM -0400, Gary wrote: > > Most of the information about mutilple tables deals with the retreval of > data from, not inserting into, meaning they are more used for known data > inserted by the database owner/administrator to be retrieved by queries into > the DB.

Re: [PHP] Inserting into multiple tables

2010-04-11 Thread Nathan Rixham
Gary wrote: > Adam > > Thank you for your well thought out response. > > Two points: > > I did not include any anti-injection functions because this was an > experiment for multiple tables, it is on my machine only. > > Since these are php scripts, I dont think anyone will mind (not to mention

Re: [PHP] Inserting into multiple tables

2010-04-11 Thread Gary
om: Gary [mailto:gwp...@ptd.net] Sent: Saturday, April 10, 2010 2:28 PM To: php-general@lists.php.net Subject: [PHP] Inserting into multiple tables I am experimenting with multiple tables, it is only a test that is my local machine only. This is the current code, which does not work , I have tried to co

RE: [PHP] Inserting into multiple tables

2010-04-10 Thread Tommy Pham
Hi Gary, > -Original Message- > From: Gary [mailto:gwp...@ptd.net] > Sent: Saturday, April 10, 2010 2:28 PM > To: php-general@lists.php.net > Subject: [PHP] Inserting into multiple tables > > I am experimenting with multiple tables, it is only a test that is my &

Re: [PHP] Inserting into multiple tables

2010-04-10 Thread Gary
Adam Thank you for your well thought out response. Two points: I did not include any anti-injection functions because this was an experiment for multiple tables, it is on my machine only. Since these are php scripts, I dont think anyone will mind (not to mention this board always provides gre

Re: [PHP] Inserting into multiple tables

2010-04-10 Thread Adam Richardson
On Sat, Apr 10, 2010 at 7:56 PM, Gary wrote: > Adam > > Thanks for your reply, but I think I am totally confused. Not so much by > your answer (although I admit I did not get it to work yet), but by the > entire multiple table issue. Several books I use talk about the importance > of using multi

Re: [PHP] Inserting into multiple tables

2010-04-10 Thread Gary
Adam Thanks for your reply, but I think I am totally confused. Not so much by your answer (although I admit I did not get it to work yet), but by the entire multiple table issue. Several books I use talk about the importance of using multiple tables, yet are thin on the insert issue. Searchi

Re: [PHP] Inserting into multiple tables

2010-04-10 Thread Adam Richardson
On Sat, Apr 10, 2010 at 5:27 PM, Gary wrote: > I am experimenting with multiple tables, it is only a test that is my local > machine only. This is the current code, which does not work , I have tried > to concatonate the insert statements. I have tried multiple $query > variables, but it is just

[PHP] Inserting into multiple tables

2010-04-10 Thread Gary
I am experimenting with multiple tables, it is only a test that is my local machine only. This is the current code, which does not work , I have tried to concatonate the insert statements. I have tried multiple $query variables, but it is just overwriting itself (only the last one gets inserte