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
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) >'
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
"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
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
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
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
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
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
> > >
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
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
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
12 matches
Mail list logo