Re: Inserting into multiple tables

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. Searching the web I have read several answers saying you simply cant insert into multiple tables at once. So if multiple tables is such an important issue, why is there no insert solution. What am I missing? Gary "Adam Richardson" <simpleshot@gmail.com> wrote in message news:x2ge4d8ea9d1004101457r62b7c0b8uc3673353c3758394@mail.gmail.com...

On Sat, Apr 10, 2010 at 5:27 PM, Gary <gwpaul@ptd.net> 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 overwriting itself (only the last one gets inserted). I also tried writing the $query as an array, which got me an error message (saying it was expecting a string and I offered an array). Someone point me in the right direction?

I'm not aware of any multi-table insert syntax: http://lists.mysql.com/mysql/171921 You'd have to perform 4 separate mysql_query() calls to accomplish what you're looking for (one for each insert.) That said, I'd recommend using a transaction so you make sure all of the inserts succeed or fail together (it would cause issues down the road if one table insert worked and another failed.) Additionally, I'd recommend using prepared statements to avoid SQL injection (I'd mention validation your POST data, too ;) See the tutorial below: http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html Adam -- Nephtali: PHP web framework that functions beautifully http://nephtaliproject.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 5016 (20100410) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature database 5016 (20100410) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com