tried this without success.
$query = "SELECT *, single_rooms+double_rooms+twin_rooms AS total
FROM properties WHERE total >2 AND total <10
R.
- Original Message - From: "Edward Kay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, May 10, 2007 10:17
Original Message -
From: "Edward Kay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, May 10, 2007 10:17 AM
Subject: RE: adding 3 values
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 10 May 2007
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: 10 May 2007 10:08
> > To: mysql@lists.mysql.com
> > Subject: adding 3 values
> >
> >
> > Hi,
> >
> > I have 3 integer values in the table
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 10 May 2007 10:08
> To: mysql@lists.mysql.com
> Subject: adding 3 values
>
>
> Hi,
>
> I have 3 integer values in the table single_rooms, double_rooms,
> twin _ooms bu
Hi,
I have 3 integer values in the table single_rooms, double_rooms, twin _ooms
but want to add them all up to do a comparison to see if the combined number of
rooms is less than ten.
Ta,
R.
