Mysql Query - getting records using less and greater than

[jattsurma]

Hi,

 

I'm trying to figure out how to select all the males from database that are within the ages of 20 - 30. I can't get the query working. If someone can point me to right direction, it will be greatly appreciated.

 

Here is my query:

 

$query = "SELECT * FROM profiles WHERE sex={$_GET['sex']}, age >= 20, age <= 30 ORDER BY pId DESC";

 

this is what I get when I echo the $query:

 

SELECT * FROM profiles WHERE sex=Male, age >= 20, age <= 30 ORDER BY pId DESC

 

Thank in advance for your help.

 

Jatt Surma

[raindropz12]

Try this

$query = "SELECT * FROM profiles WHERE sex={$_GET['sex']}, age>= 20 AND age<=30 ORDER BY pId DESC";

 

or

$query = "SELECT * FROM profiles WHERE sex={$_GET['sex']}, age BETWEEN 20 AND 30 ORDER BY pId DESC";

[ignace]

SELECT * FROM profiles WHERE sex={$_GET['sex']} AND age>= 20 AND age<=30 ORDER BY pId DESC

 

It's AND not ,

[raindropz12]

sorry I forgot to change the first comma into AND

[PFMaBiSmAd]

Sorry to throw a monkey-wrench into your data storage, but age is not a constant value (unless you are dead.) Age changes once a year (for most people.) You need to store the date of birth and calculate the age.

[jattsurma]

Thanks for your help guys.

 

I tried it out and it worked flawlessly.

 

I appreciate it.

 

Jatt Surma