NIT NO |
Document
Sale |
Head |
Description |
Details |
Opening Date |
Closing
Date |
Address
:- |
Place
:- echo $place1?> |
|
//******************************TENDER DETAILS FRO FIRST ADDRTESS *****************************
$sql="select tender_id, nit_no,date_format(opdate,'%d/%m/%y'),date_format(cpdate,'%d/%m/%y'),head,description,t_notice,t_docu,corri1,corri2,corri3,tpath,cpath1,cpath2,cpath3,mno from tender_info where source='$place1' and address ='$add1' and classification='$classi' order by mno ";
$result1 = mysql_query($sql) or Die("Could not generate tender id");
while($row=mysql_fetch_array($result1))
{
?>
echo $row[0] ?> |
echo $row[1] ?> |
echo $row[2] ?> |
echo $row['head'] ?> |
echo $row['description'] ?> |
if($row['t_notice']=="YES")
{
echo " Notice";
}
?>
|
if($row['t_docu']=="YES")
{
echo " Tender";
}
?>
|
if($row['corri1']=="YES")
{
echo " Corrigendum1";
}
?>
|
if($row['corri2']=="YES")
{
echo " Corrigendum2";
}
?>
|
if($row['corri3']=="YES")
{
echo " Corrigendum3";
}
?>
|
if($row['tender_id']=='1039')
{
echo " Clarification";
}
?>
|
|
}
?>
$sql="select * from address where address <> '$add1'";
//echo $sql;
$result = mysql_query($sql) or Die("Could not generate tender id 12");
$sno=0;
while($row=mysql_fetch_array($result))
{
//echo $row[0];
$sql="select tender_id, nit_no,date_format(opdate,'%d/%m/%y'),date_format(cpdate,'%d/%m/%y'),classification,head,description,t_notice,t_docu,corri1,corri2,corri3,tpath,cpath1,cpath2,cpath3,mno from tender_info where source= '$row[0]' and address ='$row[1]' and classification='$classi' order by mno ";
//echo $sql;
$result1 = mysql_query($sql) or Die("Could not generate tender id");
$totalrecords = @mysql_num_rows($result1);
if($totalrecords>0) // If tender exist for particular address then search all tenders for that address
{
?>
Address
:- |
Place
:- echo $row[0] ?> |
|
while($row1=mysql_fetch_array($result1))
{
?>
echo $row1[0]?> |
echo $row1[1]?> |
echo $row1[2]?> |
echo $row1['head']?>
|
echo $row1['description'] ?> |
if($row1['t_notice']=="YES")
{
echo " Notice";
}
?>
|
if($row1['t_docu']=="YES")
{
echo " Tender";
}
?>
|
if($row1['corri1']=="YES")
{
echo " Corrigendum";
}
?>
|
if($row1['corri2']=="YES")
{
echo " Corrigendum2";
}
?>
|
if($row1['corri3']=="YES")
{
echo " Corrigendum";
}
?>
|
if($row['tender_id']=='1039')
{
echo " Clerification";
}
?>
|
|
}
}
}
?>
|