[PHP-DB] Re: Zend Optimizer for PHP on Linux

I too am looking into this though with PHP5. Does anyone have any experience of this - I am also interested in benchmark results in terms of performance improvments/hits when using the optimizer both with and without SSL based websites. Reagrds, David naren pendyal wrote: Hello, Can any one

[PHP-DB] PHP5 and Multiple Database Connections

Hello Everyone! I am currently writing a sequence of php pages to help me retrieve data from a Pervasive 9.5 database, display that data in my web browser with a form built in to collect more data, and then will push the retrieved Pervasive data and the input data to MySQL. I am having

[PHP-DB] Date Translation in MySQL

I'm looking for a quick and simple way to query a MySQL database by date, or more specifically, by day of the week. My dates are stored in the DB in -MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL that will take this column and return only Saturdays, for example,

Re: [PHP-DB] PHP5 and Multiple Database Connections

Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to test ODBC connections. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Hello Everyone! I am currently writing a sequence of php pages to help me

RE: [PHP-DB] Date Translation in MySQL

Select * FROM ... WHERE DAYOFWEEK(datecol)=7 -Original Message- From: Ben Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:10 PM To: PHP. DB Mail List Subject: [PHP-DB] Date Translation in MySQL I'm looking for a quick and simple way to query a MySQL database by date,

Re: [PHP-DB] PHP5 and Multiple Database Connections

Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data. -- Original message -- From: Micah Gersten [EMAIL PROTECTED] Have you tested the DSN outside of PHP? Openoffice.org Database has facilities to

Re: [PHP-DB] PHP5 and Multiple Database Connections

What does the connector return to you when you connect in PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Yes I am sure the ODBC works as it is installed on my laptop and I use Excel to import many various queries of data.

RE: [PHP-DB] Date Translation in MySQL

Figured there had to be an easier way. Thank you so much. -Original Message- From: Simcha Younger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 2:48 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Date Translation in MySQL Select * FROM ... WHERE DAYOFWEEK(datecol)=7

Re: [PHP-DB] PHP5 and Multiple Database Connections

Here are the messages that are currently displayed and my current script: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\xampp\htdocs\test2.php on line

Re: [PHP-DB] PHP5 and Multiple Database Connections

Is it set up as a system DSN or User DSN. Try testing an app as the same user as the webserver and see if you can connect to the DSN. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: Here are the messages that are currently