RE: Sending multiple queries to MySQL (sorry, hit send by accident!)

2004-06-14 Thread SGreen
8 Fax to: PM Subject: RE: Sending multiple queries to MySQL (sorry, hit

RE: Sending multiple queries to MySQL (sorry, hit send by accident!)

2004-06-14 Thread emierzwa
. Ed -Original Message- From: Andy Hall [mailto:[EMAIL PROTECTED] Subject: Sending multiple queries to MySQL (sorry, hit send by accident!) Hi, I have a situation where, within a PHP loop, I am creating over one hundred SQL statement (INSERTS and UPDATES). Would it cut any overhead to

Sending multiple queries to MySQL (sorry, hit send by accident!)

2004-06-11 Thread Andy Hall
Hi, I have a situation where, within a PHP loop, I am creating over one hundred SQL statement (INSERTS and UPDATES). Would it cut any overhead to send 20 ";" seperated queries in one mysql_query() statement, and therefore only execute mysql_query() 5 times for 100 statements, as opposed to sen