Searching mysql

[graham23s]

Hi Guys,

 

i have knocked up a basic for with 5 fields to search, i'm having trouble with the between ages selection:

 

code:

 

  ## deal with the submission
  if(isset($_GET['search'])) {
  
  echo ("<hr />"); 
  
  ## vars
   $gender = $_GET['gender'];
  $herefor = $_GET['herefor'];
  $country = $_GET['from'];
    $frage = $_GET['fromage'];
       $to = $_GET['toage']; 
       
       //echo $gender.$herefor.$from.$frage.$to;
       
  ## compile the query
  $searchquery  = "SELECT * FROM `users` ";
  $searchquery .= "WHERE `gender`='" . $gender . "' ";
  $searchquery .= "AND `herefor`='$herefor' ";
  $searchquery .= "AND `country`='$country'";
  $searchquery .= " AND `year` BETWEEN YEAR(CURDATE() - INTERVAL $toage YEAR) AND YEAR(CURDATE() - INTERVAL $fromage YEAR)";
  
  ## run query
  $resultquery = mysql_query($searchquery);
  
  ## num results
  $numresults = mysql_num_rows($resultquery);
  
  echo $numresults;
  
  }

 

when the user selects between 18 and 50 for example, i assume thats where the problem lies is there a better way to do that all?

 

thanks guys

 

Graham

[fenway]

You're storing just the year?