Untitled Document
$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');
mysql_query("set names 'utf8'");
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='13' and CDate >= '" . date("Y/m/d") . "' order by UploadedOn DESC" . " LIMIT " . $p . ",20";
$sql1="SELECT * from tender where Type='13' 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 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 |
if($num_rows==0){ ?>
No tender found... |
}else{
for($i=0;$i<$num_rows;$i++){
?>
|