On 10 Sep 2010, at 13:59, Michael Jones wrote: > We have an application that I'm converting to PHP. There are several places > that do something like this: > > $query = "START TRANSACTION;" > $query+= "INSERT INTO a (.....)" > $query+= "INSERT INTO b (...)" > $query+= "SELECT LAST_INSERT_ID() as ID" > $query+= "COMMIT" > > Since mysql_query doesn't support multiple queries per statement, what is the > best way to do this in PHP? Right now I'm using a transaction class to put > each query in an array and loop them, but efficiently handling any return > results is a bit of a puzzle. >
Just run more queries. I guess I am not sure what you are asking. What is the end result you are looking for? _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
