Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
John Holmes wrote: I'd personally recommend ADOdb for no other reason than that's what I use and it's effective. Seconded. John Lim who wrote ADOdb is always updating it with input from users. PEARdb does seem to have caught up, but lots of third party applications are already available that use

RE: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Ed Lazor
Has any performance testing been done between ADOdb and PEARdb? -Original Message- PEARdb does seem to have caught up, but lots of third party applications are already available that use ADOdb or have moved to it (or are moving) in later updates. -- PHP Database Mailing List

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
Ed Lazor wrote: Has any performance testing been done between ADOdb and PEARdb? Not recently. Personally I am still trying to benchmark engines within ADOdb against the latest Firebird. This is an area where any results would be useful. There are speed comparisons on the ADOdb site, but they

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Jean-Philippe Côté
John, I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other direction and then I can make an educated

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread John Holmes
From: Jean-Philippe Côté [EMAIL PROTECTED] I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other

[PHP-DB] Re: Which Database Abstraction Layer ?

2004-09-02 Thread pete M
ADODB Jean-Philippe côté wrote: Hi, I'm trying to choose a database abstraction layer for a project and I'm having difficulty making up my mind. The two I'm currently looking at are: ADOdb and MDB2 (from PEAR). I was recommended to use MDB2 but its still a beta version and the documentation is

Re: [PHP-DB] Re: Newbie Questions

2004-09-02 Thread Pete Holsberg
On Wed, 1 Sep 2004, Pete Holsberg wrote: On Wed, 1 Sep 2004, Torsten Roehr wrote: Pete Holsberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to set up a directory with the following fields: surname firstname spousename housenumber street phone

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Lester Caine
Jean-Philippe Côtê wrote: I thought the point of such discussion lists as php-db was to be able to maturely discuss these questions. I understand that people have different opinions and that's exactly what I'm looking for. I'm hoping to receive pointers in one or the other direction and then I can

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

2004-09-02 Thread ioannes
Sorry to visit this once again, but this is a problem with bits the solution to which causes other problems. I need to do this in a SQL query: (arrival+nights)='$thisdate' 'arrival' is a date field, and 'nights' is an integer, so the above makes no sense, being like 2004/12/31+7 which is

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

2004-09-02 Thread ioannes
The answer seems to be DATE_ADD but I haven't got it to work yet...asking the MySQL people. I need to do this in a SQL query: (arrival+nights)='$thisdate' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Jean-Philippe Côté
Quoting Lester Caine [EMAIL PROTECTED]: I am sure if I started again now I would probably be using something other than ADOdb. But at the time it fitted the bill and where there were problems they were quickly cleared. Unlike some of the other options I tried. May I ask which other ones you

Re: [PHP-DB] Re: Newbie Questions

2004-09-02 Thread Torsten Roehr
Pete Holsberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, 1 Sep 2004, Pete Holsberg wrote: On Wed, 1 Sep 2004, Torsten Roehr wrote: Pete Holsberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to set up a directory with the following

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

2004-09-02 Thread Ed Lazor
Quoting ioannes [EMAIL PROTECTED]: The answer seems to be DATE_ADD but I haven't got it to work yet...asking the MySQL people. Check your version of MySQL... I think that's a newer function. -Ed This message was sent using

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

2004-09-02 Thread ioannes
The code that seems to work eventually is: $thisdate=date(Y-m-d,$thisdate); // does not work where the delimiter is / rather than -, I thought various delimiters were allowed in the relaxed mysql code! $query=SELECT WHERE..arrival='$thisdate' DATE_ADD(arrival,INTERVAL nights-1 DAY)

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-02 Thread Hans Lellelid
Jean-Philippe Côtê wrote: Quoting Lester Caine [EMAIL PROTECTED]: I am sure if I started again now I would probably be using something other than ADOdb. But at the time it fitted the bill and where there were problems they were quickly cleared. Unlike some of the other options I tried. May I ask