About Us
24 Hours
Top Doctor
Best Care
Patient
='$today' order by schedule.scheduledate asc";
$sqlpt1="";
$insertkey="";
$q='';
$searchtype="All";
if($_POST){
//print_r($_POST);
if(!empty($_POST["search"])){
$keyword=$_POST["search"];
$sqlmain= "select * from schedule inner join doctor on schedule.docid=doctor.docid where schedule.scheduledate>='$today' and (doctor.docname='$keyword' or doctor.docname like '$keyword%' or doctor.docname like '%$keyword' or doctor.docname like '%$keyword%' or schedule.title='$keyword' or schedule.title like '$keyword%' or schedule.title like '%$keyword' or schedule.title like '%$keyword%' or schedule.scheduledate like '$keyword%' or schedule.scheduledate like '%$keyword' or schedule.scheduledate like '%$keyword%' or schedule.scheduledate='$keyword' ) order by schedule.scheduledate asc";
//echo $sqlmain;
$insertkey=$keyword;
$searchtype="Search Result : ";
$q='"';
}
}
$result= $database->query($sqlmain)
?>