Re: [PHP] Re: Multiple MySQL INSERT into loop

On Thu, 2008-02-07 at 10:55 +, Colin Guthrie wrote: > Simplest way would be to define your data in an array instead: > > e.g. $data = array(1 => array('id' => x, 'entry' => y, 'name' => z), ...). > And of course to tie it all into a transaction that can be rolled back in case of problems.

[PHP] Re: Multiple MySQL INSERT into loop

Rob G wrote: > //BEGIN EXAMPLE > > > > mysql_query ("INSERT INTO testimonials (id, quote, name) VALUES ('$id_1', > '$entry_1', '$name_1')"); > > > > mysql_query ("INSERT INTO testimonials (id, quote, name) VALUES ('$id_2', > '$entry_2', '$name_2')"); > > > > mysql_query ("INSERT INTO te