On Fri, Sep 12, 2003 at 03:16:41PM +1000, Daniel Rossi wrote: > > hi there, i am trying to use transactions on some innodb tables although a few > things i am experiencing, on one query the value appears, i refresh the page and the > value dissapears again, i am using persistant connections in php, the value is > actually there in the console, what could be the prob ?
Are you running with AUTOCOMMIT=0 and forgetting to COMMIT? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 179,565,412 queries (447/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
