include('auth_inc.php');
//error_reporting(0); ?>
$today=date('Y-m-d H:i:s');
//echo $today;
$keyword=$_POST["keyword"];
$wing=$_POST["wing"];
if($keyword==''){echo " enter a key word min 3 letters ";}else{
if($wing=='telecom'){
$qry="select 'telecom' ww, ssaname xx,tender_name yy,link zz,lastday,lastmonth,lastyear,lasthr,lastmnt,openday,openmonth,openyear,openhr,openmnt from tenders.telecom where (tender_name like '%$keyword%' or ssaname like '%$keyword%') and lastdatetime>='$today' order by id desc";
} else if($wing=='electrical'){
$qry="select 'electrical' ww, division xx,tender_name yy,link zz,lastday,lastmonth,lastyear,lasthr,lastmnt,openday,openmonth,openyear,openhr,openmnt from tenders.electrical where (tender_name like '%$keyword%' or division like '%$keyword%') and lastdatetime>='$today' order by id desc";
} else if($wing=='civil'){
$qry="select 'civil' ww, division xx,tender_name yy,link zz,lastday,lastmonth,lastyear,lasthr,lastmnt,openday,openmonth,openyear,openhr,openmnt from tenders.civil where (tender_name like '%$keyword%' or division like '%$keyword%') and lastdatetime>='$today' order by id desc";
}
$rs=mysql_query($qry,$mycon);
$num=mysql_num_rows($rs);
//echo $qry;
?>
Division |
name of tender |
last day ofsubmission |
opening day |
if ($num>0){?>
$pslno=0;
while($row=mysql_fetch_array($rs)){
$pslno++;
?>
|
|
-
-
:
|
-
-
:
|
} //while?>
} else {?>
No result for your keyword. Try with a new one |
} ?>
} //for echo?>
HOME
|