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 d

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 dir

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

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 probab

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

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 direct

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 as