$total=30;
$page=$_POST['page'];
if($page==""){
$begin=0;
}
else{
$begin=($page-1)*$total;
}
function showgrant($value){
if($value==1){
return "
/";
}
else{
return "
-";
}
}
$states=$_POST['states'];
$fac_id=$_POST['fac_id'];
$dept_id=$_POST['dept_id'];
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$sql="SELECT ";
$sql.="a.dept_name as fac_name,follow_department.dept_name as dept_name,prefix_name,fname,lname,phones,emails,plan_grant,stock_grant,money_grant,gen_code,statuss ";
$sql.="FROM ";
$sql.="(regis_grant ";
$sql.="inner join ";
$sql.="follow_department as a ";
$sql.="on ";
$sql.="regis_grant.dept_id=a.dept_id) ";
$sql.="inner join ";
$sql.="follow_department ";
$sql.="on ";
$sql.="regis_grant.fac_id=follow_department.dept_id ";
$sql.="where ";
if($states!="fac"){
$sql.="fac_id like '$fac_id%' and ";
}
$sql.="regis_grant.dept_id like '$dept_id%' and fname like '$fname%' and lname like '$lname%'";
$sql2=$sql." limit $begin,$total";
$result=mysql_query($sql2,$conn);
?>