sending multiple UPDATE queries to mySQL?
Posted: Thu Aug 17, 2006 10:47 am
Hello,
My grasp of mySQL is just strong enough to do the things I need to do, so please bear with me.
I need to send multiple update queries to mySQL (updating a range of records won't do here), and I was wondering if it was possible to send them all at once rather than individually. I tried separating the queries with semi-colons in a variable called $q and then doing but I got a syntax error.
There are about 500 records to update, and I'd prefer not to ding mySQL 500 times if possible.
Thanks.
My grasp of mySQL is just strong enough to do the things I need to do, so please bear with me.
I need to send multiple update queries to mySQL (updating a range of records won't do here), and I was wondering if it was possible to send them all at once rather than individually. I tried separating the queries with semi-colons in a variable called $q and then doing
Code: Select all
$result = mysql_query($q) ;There are about 500 records to update, and I'd prefer not to ding mySQL 500 times if possible.
Thanks.