[thelist] MySql Rollback in PHP within a website

[Aredridel]

> It's my understanding that I need to somehow set "START TRANSACTION" prior
> to beginning the update. But I'm not sure how to do that within the PHP
> code... Nor am I sure if there's something else I need to do...

"START TRANSACTION" is simply an SQL command.  Just execute:

mysql_query("START TRANSACTION");

do your coding, then

mysql_query("COMMIT");

do be aware that the features for that only exist in mysql 4, though.

> 
> Any examples/hints/sample code will be appreciated. Thanks for any
> assistance!
> 
> Regards,
> 
> Bruce
> bedouglas at earthlink.net
> (925) 866-2790
>