[PHP-DB] Re: noobie db: oracle?

2002-09-06 Thread :B nerdy
anyone know anything about oracle php at all? =D :B Nerdy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... ive been using mysql my whole php life. i recently got oracle trial db. how does it weigh against mysql? is there a website really benchmarks th

[PHP-DB] [mysql] query atomicity

2002-09-04 Thread :B nerdy
how would i go about making a few queries into a transaction - that is, if one of them fails, the previous queries get rolled back... cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [mysql] query atomicity

2002-09-04 Thread :B nerdy
e (k1,k2) values (5,3);'); you must have in the rollback array this $rollback_ar = array('DELETE FROM some_table WHERE k1=4 and k2=2;', 'DELETE FROM some_table WHERE k1=5 and k2=3'); Hope this is clear. Best regards Andrey Hristov - Original Message - From: :B nerdy [EMAIL P

[PHP-DB] [mysql] query wierness :/

2002-09-03 Thread :B nerdy
this function doesnt work function query($sql) { return mysql_query($sql, $this-mysql_link) or die(query failed: $sql); } but this one does function query($sql) { $mysql_result = mysql_query($sql, $this-mysql_link) or

[PHP-DB] noobie db: oracle?

2002-09-02 Thread :B nerdy
ive been using mysql my whole php life. i recently got oracle trial db. how does it weigh against mysql? is there a website really benchmarks them both against each other, practically? cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] [mysql] freeing resources

2002-09-02 Thread :B nerdy
what would happen if i do not use mysql_free_result() and mysql_close() for my scripts. i presuming it doesnt leak memory. if so, then why not just forget about them, and let the automatic freeing thingie's do the work? cheers -- PHP Database Mailing List (http://www.php.net/) To