i m stuck in a small problem. i have to generate a report for 3 categories. each category i want to show on the different page. Table is successfully generated but all 3 tables are coming on the same page. i have 3 different while loop to generate those table. it is not fixed that how many rows will come in the first table but i think single page will be enough for each table.
please help me to get the tables to 3 different pages. below is the code for first table(first while loop)
Code: Select all
$page=1;
$sno=1;
$fp=fopen("groupleader.doc","a+");
$groupleader2=mysql_query("SELECT * FROM groupleader WHERE PSRN='$psrn' AND LOCATION='$location'") or die("Query failed with error: ".mysql_error());
while($data1=mysql_fetch_array($groupleader2,MYSQL_ASSOC)) //or die("Query failed with error: ".mysql_error());
{
$ip_phone=$data1['IP_PHONE'];
$ip_o=$data1['IP_O'];
$ip_r=$data1['IP_R'];
$tab_2='<table width="600" border="1" align="center" cellpadding="3" style="border: solid 2px black;" >';
$string1='<tr bgcolor="#99CCFF"><td colspan="4"><center>Detail of the VOIP Phone</center></td></tr>';
$string2='<tr bgcolor="#99CCFF"><td><center>S.N.</center></td>'.'<td><center>VOIP MODEL </center></td>'.'<td><center>VOIP OFFICE NUMBER </center></td>'.'<td><center>VOIP RESIDENCE NUMBER</center></td></tr>';
$data2='<tr><td><center>'.$sno.'</center></td>'.'<td NOWRAP><center>'.$ip_phone.'</center></td>'.'<td NOWRAP><center>'.$ip_o.'</center></td>'.'<td NOWRAP><center>'.$ip_r.'</center></td></tr>';
if($page==1)
{
fwrite($fp,$str1);
fwrite($fp,$str2);
fwrite($fp,$str3);
fwrite($fp,$str4);
fwrite($fp,$str4."<br>");
fwrite($fp,$head1);
}
if($sno==1)
{
fwrite($fp,$tab_2);
fwrite($fp,$string1);
fwrite($fp,$string2);
}
if($ip_phone<>"")
{
fwrite($fp,$data2);
$sno++;
}
$page++;
}
$tab_22="</table><br><br>";
fwrite($fp,$tab_22);
$line2="<br><br><br><br><br><br><br>Issued By".str_repeat(" ",180)."Signature";
$fp=fopen("groupleader.doc","a+");
fwrite($fp,$line2);
fclose($fp);