php mysql BETWEEN FUNCTION QUERY??

[antonyfal]

Hi,

Doing a Query SELECT * FROM table WHERE field BETWEEN low_number AND high_number

 

If i have three rows with three numbers: IE: 27, 50, 80.

and i run the query above, it returns a result of:

27 and 50.

 

How can i get it to return a result of:

27,50, and 80.??

 

WHY:

age range search: i want to return an age range of people = and between the age of say: 20 and 70 but i want to include the 20 and 70.

How can i do this?

 

[paparts]

select * from table where age >= 20 and age <=70;

[PFMaBiSmAd]

Unless a person is dead, their age is not a constant number. It changes once a year on their birthday.

 

You need to store the date of birth and then to find age ranges, perform a date comparison that corresponds to the correct birthday date range calculated relative to the current date.

[antonyfal]

Thanks Insane.

Works well. I dont know why i had the BETWEEN function stuck in my head.

 

Thanks again.

[Pikachu2000]

I agree with PFMaBiSmAd, but a BETWEEN query should work fine if you insist on proceeding with what you have. If you read the manual entry, you'll see that the values used in the BETWEEN comparison are inclusive.