Need some help with multiple PHP/MySQL INSERT statements

[Jack]

Re: Need some help with multiple PHP/MySQL INSERT statements

Garp wrote:

[color=blue]
>
> I looked up my old code; I was parsing out the INSERT stuff and repeating
> the VALUES section over and over. Turn these:
>
> INSERT INTO table VALUES ('a','b','c')
> INSERT INTO table VALUES ('d','e','f')
> INSERT INTO table VALUES ('g','h','i')
>
> into this:
>
> INSERT INTO table VALUES ('a','b','c'),( 'd','e','f'),(' g','h','i')
>
> I *knew* I'd done it somehow.
>[/color]

THANK YOU GARP!! That works perfectly! Now I'll go back and rewrite the
way the add2db.txt gets written to conform with this. I appreciate your
help (as well as Michael's and Virgil's) in getting this working.

Then I'll move on to tackle calling this script with a submit button
instead of having it execute on loading. But I can do that... I think.
;) LOL!