[PHP-DB] Strange problem between PHP and MySQL

2006-10-09 Thread Pierre Pintaric
Hello there, This week-end, I had a strange problem. I had to recompile my PHP versions (PHP 4.4.4 and PHP 5.1.6) to add XSLT support. For the compilation, I did nothing special: ./configure --prefix=/usr/local/php4 --with-config-file-path=/usr/local/lib/php4 --with-pear=/usr/share/php4

Re: [PHP-DB] mysqli auto rollback on script termination

2006-10-09 Thread Martin Koch Andersen
Chris skrev: It should be rolled back when a connection is lost or a transaction isn't explicitly committed. Can you find documentation on this specific issue anywhere? I think the same as you, but I find it odd, it is not documented. Reason I'm asking is, I've seen some deadlock issues in a

Re: [PHP-DB] mysqli auto rollback on script termination

2006-10-09 Thread Chris
Martin Koch Andersen wrote: Chris skrev: It should be rolled back when a connection is lost or a transaction isn't explicitly committed. Can you find documentation on this specific issue anywhere? I think the same as you, but I find it odd, it is not documented. Reason I'm asking is, I've

[PHP-DB] What's the PHP equivallent of mysql mydb somefile.sql

2006-10-09 Thread Daevid Vincent
Currently I run an 'updater' script to run through a directory of .sql files using something like this in PHP: $COMMAND = mysql .$OPTION['db_prefix'].$db. .$mydir.$filename; system($COMMAND, $ret); What would be the equivallent way to to this in a PHP mysql_query(); way? I see