> If I'm doing more than one query on a page what is the best way to check
if
> they all succeeded with out using transactions?
You can check each query as it executes, and (perhaps) have your program
logic do something intelligent in the case of individual failures.
Another possbility is to do all the queries on some temporary table, and
then do one "big" query that inserts/updates from the temp table to the
"real" table...
In general, though, once you get a good connection, and if your SQL is
valid, queries don't fail very often... Not something you can rely on for
mission-critical usage, but you may be over-worried about an infrequent
event. Perhaps you could just code it to dump everything to an email to
yourself if it ever pukes, so you can fix it by hand.
(Kinda dangerous since it could flood your email box if the db goes down
completely and you can't get to it to fix it...)
--
WARNING [EMAIL PROTECTED] address is not working -- Use [EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
