edwinbiasbas
New member
...other in the same page? For example:
<td width="235"><p>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="1003"; // Mysql password
$db_name="permanent2008"; // Database name
$tbl_name="customer"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE oryear LIKE '2008' AND ormonth LIKE 'January' order by pnum";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);
?>
</p>
<table bgcolor="white" width="235" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="7" align="center" bgcolor="#0000FF"><div align="left"><span class="style153"> REPORT ON PERMANENT BUSINESS REGISTERED FOR CY 2008</span></div></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><p align="left" class="style151">JANUARY <br />
</p></td>
</tr>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF" class="style152"><div align="left"><?php echo 'Total Permits Registered: '."$num_rows \n"; ?></div></td>
</tr>
<tr>
<td width="97" align="center" bgcolor="#FFFFFF" class="style148"><span class="style18">Year</span></td>
<td width="135" align="center" bgcolor="#FFFFFF" class="style148"><span class="style18">Owner</span></td>
<td width="99" colspan="3" rowspan="2" align="center" bgcolor="#FFFFFF" class="style148">* </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF" ><div align="center"><span class="style148"><? echo $rows['oryear']; ?></span></div></td>
<td bgcolor="#FFFFFF" ><span class="style148"><? echo $rows['pnum']; ?>, <span class="style149"><? echo $rows['fname']; ?> <span class="style150"><? echo $rows['mname']; ?></span></span></span></td>
</tr>
<?php
}
?>
</table>
</td>
<td width="929" align="top"><p>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="1003"; // Mysql password
$db_name="comparative"; // Database name
$tbl_name="customer"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE oryear LIKE '2009' AND ormonth LIKE 'January' order by pnum ";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);
?>
</p>
<table bgcolor="white" width="236" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="7" align="center" bgcolor="#0000FF"><div align="left"><span class="style141"> REPORT ON PERMANENT BUSINESS REGISTERED FOR CY 2008</span></div></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><p align="left" class="style139">JANUARY <br />
</p></td>
</tr>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF" class="style140"><div align="left"><?php echo 'Total Permits Registered: '."$num_rows \n"; ?></div></td>
</tr>
<tr>
<td width="97" align="center" bgcolor="#FFFFFF" class="style136"><span class="style18">Year</span></td>
<td width="135" align="center" bgcolor="#FFFFFF" class="style136"><span class="style18">Owner</span></td>
<td width="4" colspan="3" rowspan="2" align="center" bgcolor="#FFFFFF" class="style136">* </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF" ><div align="center"><span class="style136"><? echo $rows['oryear']; ?></span></div></td>
<td bgcolor="#FFFFFF" ><span class="style136"><? echo $rows['pnum']; ?>, <span class="style137"><? echo $rows['fname']; ?> <span class="style138"><? echo $rows['mname']; ?></span></span></span></td>
</tr>
<?php
}
?>
</table>
</td>
With output:
Database 1 Database 2
1 John
2. Jimmy 1. Helen
2. Tommy
Desired Output :
1. John 1. Helen
2. Jimmy 2. Tommy
<td width="235"><p>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="1003"; // Mysql password
$db_name="permanent2008"; // Database name
$tbl_name="customer"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE oryear LIKE '2008' AND ormonth LIKE 'January' order by pnum";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);
?>
</p>
<table bgcolor="white" width="235" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="7" align="center" bgcolor="#0000FF"><div align="left"><span class="style153"> REPORT ON PERMANENT BUSINESS REGISTERED FOR CY 2008</span></div></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><p align="left" class="style151">JANUARY <br />
</p></td>
</tr>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF" class="style152"><div align="left"><?php echo 'Total Permits Registered: '."$num_rows \n"; ?></div></td>
</tr>
<tr>
<td width="97" align="center" bgcolor="#FFFFFF" class="style148"><span class="style18">Year</span></td>
<td width="135" align="center" bgcolor="#FFFFFF" class="style148"><span class="style18">Owner</span></td>
<td width="99" colspan="3" rowspan="2" align="center" bgcolor="#FFFFFF" class="style148">* </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF" ><div align="center"><span class="style148"><? echo $rows['oryear']; ?></span></div></td>
<td bgcolor="#FFFFFF" ><span class="style148"><? echo $rows['pnum']; ?>, <span class="style149"><? echo $rows['fname']; ?> <span class="style150"><? echo $rows['mname']; ?></span></span></span></td>
</tr>
<?php
}
?>
</table>
</td>
<td width="929" align="top"><p>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="1003"; // Mysql password
$db_name="comparative"; // Database name
$tbl_name="customer"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE oryear LIKE '2009' AND ormonth LIKE 'January' order by pnum ";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);
?>
</p>
<table bgcolor="white" width="236" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="7" align="center" bgcolor="#0000FF"><div align="left"><span class="style141"> REPORT ON PERMANENT BUSINESS REGISTERED FOR CY 2008</span></div></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><p align="left" class="style139">JANUARY <br />
</p></td>
</tr>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF" class="style140"><div align="left"><?php echo 'Total Permits Registered: '."$num_rows \n"; ?></div></td>
</tr>
<tr>
<td width="97" align="center" bgcolor="#FFFFFF" class="style136"><span class="style18">Year</span></td>
<td width="135" align="center" bgcolor="#FFFFFF" class="style136"><span class="style18">Owner</span></td>
<td width="4" colspan="3" rowspan="2" align="center" bgcolor="#FFFFFF" class="style136">* </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF" ><div align="center"><span class="style136"><? echo $rows['oryear']; ?></span></div></td>
<td bgcolor="#FFFFFF" ><span class="style136"><? echo $rows['pnum']; ?>, <span class="style137"><? echo $rows['fname']; ?> <span class="style138"><? echo $rows['mname']; ?></span></span></span></td>
</tr>
<?php
}
?>
</table>
</td>
With output:
Database 1 Database 2
1 John
2. Jimmy 1. Helen
2. Tommy
Desired Output :
1. John 1. Helen
2. Jimmy 2. Tommy