[PHP-DB] odbc unable to connect

2006-05-04 Thread pons
Subj: Connect Oracle 10g using ODBC on Linux platform I found message when I connect to ORACLE through my Explorer. Here: Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /srv/www/htdocs/sdc

[PHP-DB] optimizing indexes -mysql

2006-05-04 Thread blackwater dev
I just doubled the size of my MySQL db, is there a command I should run to re-index everything or is that automatic? Thanks!

Re: [PHP-DB] preg_replace help!

2006-05-04 Thread Martin Alterisio
2006/5/3, Nathan Heaps <[EMAIL PROTECTED]>: Ok, scratch that, new problem. what can I replace (.*?) with in order for php to recognise a multi-line quote/bold/italic/code/whatever? By default the "." pattern matches anything except a line break you can either use ((?:.|\n)*) or add a modifier

Re: [PHP-DB] preg_replace help!

2006-05-04 Thread Martin Alterisio
2006/5/4, Martin Alterisio <[EMAIL PROTECTED]>: 2006/5/3, Nathan Heaps <[EMAIL PROTECTED]>: > Ok, scratch that, new problem. what can I replace (.*?) with in order > for > php to recognise a multi-line quote/bold/italic/code/whatever? By default the "." pattern matches anything except a line

Re: [PHP-DB] optimizing indexes -mysql

2006-05-04 Thread Miles Thompson
At 08:44 AM 5/4/2006, blackwater dev wrote: I just doubled the size of my MySQL db, is there a command I should run to re-index everything or is that automatic? Thanks! Well, it is automatic and MySQL does not need a lot of attention. Having said that, what table type(s) are you using, and wh

Re: [PHP-DB] preg_replace help!

2006-05-04 Thread Nathan Heaps
thanks, its fixed now!!! - Original Message - From: Martin Alterisio To: Nathan Heaps Cc: Liber ; John Hicks ; php-db@lists.php.net Sent: Thursday, May 04, 2006 11:34 AM Subject: Re: [PHP-DB] preg_replace help! 2006/5/4, Martin Alterisio <[EMAIL PROTECTED]>: 2006/5/3, Nathan Heaps <