I need to add it to forum profiles avatars

We have a forum (Php) for our school cadets and want to know how to make available in search

cadets in age range.
in our forum database Mysql there is no feild of age. but it out puts age of cadet through a code
which calculates cadet's age from db feilds cadet_birthday,
cadet_birthmonth and cadet_birthyear

and in profile it says
cadet
name: lalit
age : 16
gendre : male
class: 8th

can you tell me how to make a mysql search code for searching cadets for a particular range like e.g.

search cadets

gender=emale
age= 10 to 15

php code :
<?php
$max_results = 10;
$from = (($page * $max_results) - $max_results);

$get_results = mysql_query("SELECT * FROM cadetforum_users WHERE cadet_gender='".$_GET['gender']."' AND cadet_class='".$_GET['class']."' AND cadet_rank='".$_GET['rank']."' AND cadet_section='".$_GET['section']."' AND active_status='".$_GET['online']."' AND profile_picture='".$_GET['picture']."' LIMIT $from, $max_results");

?>


Regards,

hitesh

hitest,

You could use the > < in the MySQL Statement but I like Filtering the results in PHP.

So you could do this

PHP Code:


for ($i = 0; $row = mysql_fetch_assoc($get_results); $i++) {

     if ($row['age'] < 15 && $row['age'] > 10) {
     // Do what you want with the information
    }
} 


Hope that helps

Do that in SQL !
It's designed for that !

PHP Code:

$sql=<<<SQL
SELECT *
FROM cadetforum_users 
WHERE cadet_gender=''{$_GET['gender']}
AND cadet_class='{$_GET['class']}
AND cadet_rank='{$_GET['rank']}'
AND cadet_section='{$_GET['section']}'
AND active_status='{$_GET['online']}'
AND profile_picture='{$_GET['picture']}' 
AND cadet_age BETWEEN {$_GET['ageMin']} AND {$_GET['ageMax']}
LIMIT $from, $max_results
SQL;
$r=mysql_query($sql); 


Of course, adapt the field name to your db schema...

I would suggest putting the birthdate into one field with a data type of date. Using the proper data type in your schema will make your life a whole lot easier when it come to writing your queries. Read this page on dates and I think it will become very apparent why.
http://dev.mysql.com/doc/refman/5.0/...functions.html