mysql -> searching age between two numbers.. help pls, asap... thanks!

[kikki]

Hey,
I really need help.. let me explain the problem..

how to search mysql for results between two ages?
this question isn't clear? ok, check out this sql.. I must be doing something wrong here..

//-----------------age1...x...age2
if( ($age1 !== 'any') && ($age2 !== 'any') )
{ 
$query = "SELECT * FROM friends WHERE ((age='$age1'<'$age2')) ORDER by id DESC ";
}

thanks!

[drew010]

id do

if( ($age1 !== 'any') && ($age2 !== 'any') )
{ 
$query = "SELECT * FROM friends WHERE age > $age1 AND age < $age2 ORDER by id DESC ";
}  

[kikki]

thankyou very much drew010, I really appreciate your help...

your code works perfectly!

{
$query = "SELECT * FROM friends WHERE age >= $age1 AND age <= $age2 ORDER by id DESC "; 
}

thnx again!