[thelist] MySql Rollback in PHP within a website
Aredridel
aredridel at nbtsc.org
Sun Jul 13 16:01:47 CDT 2003
> 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
>
More information about the thelist
mailing list