[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?

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

2002-09-04 Thread :B nerdy
(4,2);'); > $r1 = mysql_query('insert into some_table (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'); > &g

[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

[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 d

[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 unsubscribe

[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: http://www.php.net/unsub.p