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" <simples...@gmail.com> wrote in message news:x2ge4d8ea9d1004101457r62b7c0b8uc3673353c3758...@mail.gmail.com...
On Sat, Apr 10, 2010 at 5:27 PM, Gary <gwp...@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




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to