how to select with condition, if no condition set, select everything?

Hi,

I would like to select only the girls or only 3rd graders in a school in a query. But if there is no criteria being set, (no requirement to select girls or 3rd graders then select every student.
How would I go about this in a sql?


Thanks for help in advanced.

 

Hi,Do you still need help on this?

 

Please post your table scheme. It will help create mysql query.

 

More details are needed indeed, but i think you need something like if (girls condition) cond = " sex = feminin " elseif (3rd grader condition) cond = " grade = 3" else cond = " 1 ".

 

if (!$searchstring==''){
if ($searchstring=='female') {
$user_cond = "gender='$searchstring'";
} else {
$user_cond = "grade='$searchstring";
}
} else $user_cond='1';

$result = mysql_query("SELECT `id`,`grade`,`gender` FROM students WHERE
$user_cond
") or die (mysql_error());