View>>> Advertisements| Notifications| Corrigendums| Cancellations| General Notifications| Status Bulletin |
e-Tender | Open (Manual) | Turnkey Tender | Limited Tender Enquiry | Expression of Interest |
$qq = $_GET['q']; switch ($qq) { case 'Buy': $q=1; break; case 'Empanelment': $q=2; break; case 'Auction': $q=3; break; case 'Work Contract': $q=4; break; case 'Service Contract': $q=5; break; case 'Sell': $q=6; break; case 'Open (Manual)': $q=7; break; case 'Limited Tender Enquiry': $q=8; break; case 'e-Tender': $q=9; break; case 'Expression of Interest': $q=10; break; } include '../../settings_tender1.php'; // include 'user/showcategory.php'; $link = mysql_connect($host, $user, $pass) or die('Could not connect: ' . mysql_error()); mysql_select_db($database) or die('Could not select database'); if(isset($_GET['p'])){ $p=$_GET['p']; }else{ $p=0; } if(isset($_GET['pcat'])){ $c=$_GET['pcat']; }else{ $c=$_GET['c']; } //$sql1="SELECT tender.*,tenderitem.* from tender,tenderitem where tender.RefNo=tenderitem.RefNo and tenderitem.Category='" . $c . "' and tender.CDate >= '" . date("Y/m/d") . "' order by tender.UploadedOn DESC" . " LIMIT " . $p . ",20"; //$sql1="SELECT * from tender where Type='9' and CDate >= '" . date("Y/m/d") . "' order by UploadedOn DESC" . " LIMIT " . $p . ",20"; $sql1="SELECT * from tender where tender.Value='0' and Type='9' order by UploadedOn DESC" . " LIMIT " . $p . ",50"; //echo $sql1; $result = mysql_query($sql1); $num_rows = @mysql_num_rows($result); $sql5="SELECT tender.*,tenderitem.* from tender,tenderitem where tenderitem.Value='0' and tender.Value='0' and tender.RefNo=tenderitem.RefNo and tenderitem.Category='" . $c . "' and tender.CDate >= '" . date("Y/m/d") . "' order by tender.CDate DESC"; //echo $sql1; $result5 = mysql_query($sql5); $num_rows5 = @mysql_num_rows($result5); //mysql_close($link); ?>
Area | Reference No. | Tender Title | Sale Open | Sale Close | Tender Opening | Uploaded On |
No tender found, search again | ||||||