query("select * from sch_teacher where user = '".$_SESSION['user']."'"); if(mysql_num_rows($rs)){ $rs = mysql_fetch_assoc($rs); if(strlen($rs['zc_time'])){ // is teacher $expireddate = date("Y-m-d h:i:s A", $rs['yx_time']); }else{ // is member $rs= $db->query("select * from agent where username = '".$_SESSION['user']."'"); $rs = mysql_fetch_assoc($rs); $expireddate = $rs['expireddate']; } //print_r(mysql_fetch_assoc($rs)); } ?>

Member Name : Expired Date :