echo mysql_result($result, $i,"Area"); ?> |
echo mysql_result($result, $i,"AdvertisementNo");
include '../../settings_tender1.php';
$link = mysql_connect($host, $user, $pass) or die('Could not connect: ' . mysql_error());
mysql_select_db($database) or die('Could not select database');
$sql11="SELECT * from CAN_advertisement1 where AdvertisementNo='". mysql_result($result, $i,"AdvertisementNo")."'";
//echo $sql11;
$result11 = mysql_query($sql11);
$num_rows11 = @mysql_num_rows($result11);
//echo $num_rows11;
if($num_rows11 > 0){
for($ii2=0;$ii2<$num_rows11;$ii2++){
echo " Cancelled";
}
}
mysql_close($link);
?>
|
echo mysql_result($result, $i,"Description"); ?> |
echo date_format(date_create(mysql_result($result, $i,"DisplayDate")),'d-m-Y'); ?>
|
$m1=mysql_result($result, $i,"tmm");
switch($m1){
case "January": $m="01";break;
case "February": $m="02";break;
case "March": $m="03";break;
case "April": $m="04";break;
case "May": $m="05";break;
case "June": $m="06";break;
case "July": $m="07";break;
case "August": $m="08";break;
case "September": $m="09";break;
case "October": $m="10";break;
case "November": $m="11";break;
case "December": $m="12";break;
}
echo "";
$dteupto=mysql_result($result, $i,"tdd")."-".$m."-".mysql_result($result, $i,"tyyyy");
echo $dteupto;
/*$dteupto1 = date_create($dteupto);
$dteuptochk=date_format($dteupto1, 'd-m-Y');
$dte=date("d-m-Y");
echo " " . $dte . " " . $dteuptochk;*/
?>
|
$upd = mysql_result($result, $i,"tdd");
$g = mysql_result($result, $i,"tmm");
switch($g)
{
case "Jan": $upm="01"; break;
case "February": $upm="02"; break;
case "March": $upm="03"; break;
case "April": $upm="04"; break;
case "May": $upm="05"; break;
case "June": $upm="06"; break;
case "July": $upm="07"; break;
case "August": $upm="08"; break;
case "September": $upm="09"; break;
case "October": $upm="10"; break;
case "November": $upm="11"; break;
case "December": $upm="12"; break;
}
$upy = mysql_result($result, $i,"tyyyy");
$updt = $upy."-".$upm."-".$upd; //echo " ".$updt;
//if (mysql_result($result, $i,"Document")==''){
// echo "Document Not Available";
// }else{
$tdt= date('Y-m-d',strtotime(mysql_result($result, $i,"DisplayDate")));
//echo " ". date('Y-m-d');
//if (date('Y-m-d',strtotime(DisplayDate)) >= date('Y-m-d') && (date('Y-m-d') <= date('Y-m-d',strtotime($updt)))){
if (tdt >= date('Y-m-d') && date('Y-m-d') <= $updt){
?>
|