Searching a range within mySQL

[Anon]

Hi,

I am trying to pull all the records with in a range in mySQL. When a user signs up they type their age in. with the search that we have set up I had written switch statements to call all the records from [18-21] etc. However it just doesn't call any records in general.

Any hints?

Thanks in Advance!

Kelly

switch($CAge){
case "1821":
$Qage = "[18-21]";
break;
case "2225":
$Qage = "[22-25]";
break;
case "2629":
$Qage = "[26-29]";
break;
case "3033":
$Qage = "[30-33]";
break;
case "3437":
$Qage = "[34-37]";
break;
case "3841":
$Qage = "[38-41]";
break;
case "4245":
$Qage = "[42-45]";
break;
case "4649":
$Qage = "[46-49]";
break;
case "5060":
$Qage = "[50-60]";
break;
case "6199":
$Qage = "[61-99]";
break;
default:
$Qage = "%";
} //end age switch

[[deleted]]

If you're talking about retrieving records from a MySQL database with a range the use the BETWEEN clause:

SELECT 'X' FROM TABLE WHERE AGE BETWEEN 21 AND 31;