need help to arrange the data correctly

chinna

hi there....i try to display the data in a table..but it was messy...here i submit my coding...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style3 {
	font-size: 24px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
-->
</style>
<link href="payment.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style4 {font-size: 14px}
.style5 {
	font-size: 9px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
-->
</style>
</head>
<body>
<p class="style3"><img src="images/computer.jpg" width="72" height="69" /><span class="style4">View E-Payment Status</span></p>
<table width="733" border="1" cellpadding="1" cellspacing="0" bordercolor="#000000">
  <tr>
    <td width="174" bgcolor="#C2EAEF">Transaction Id</td>
    <td width="139" bgcolor="#C2EAEF">Purpose </td>
    <td width="136"  bgcolor="#C2EAEF">Requestor</td>
    <td width="50"  bgcolor="#C2EAEF">Sect Manager</td>
    <td width="50"  bgcolor="#C2EAEF">Unit manager</td>
    <td width="50"  bgcolor="#C2EAEF">FM </td>
    <td width="50"  bgcolor="#C2EAEF">FD </td>
    <td width="50"  bgcolor="#C2EAEF">ED</td>
 <!--   <td width="105" bgcolor="#C2EAEF"><div align="center">ACTIONS</div></td>-->
  </tr>

  <?
  include "db1.php";
  $sql="select * from voucher ";
  $result=mysql_query($sql)or die(mysql_error());
  while($r=mysql_fetch_assoc($result))// to make the data repeated
  {
  ?>
  <tr>
    <td><span class="style5"><? echo $r['t_id'];?></span></td>
    <td><? echo $r['purpose'    ];?></td>
    <td><? echo $r['prepare_by'];?></td>

<?
}
?>
 <?
  include "db1.php";
  $sql="select * from details ";
  $result=mysql_query($sql)or die(mysql_error());
  while($r=mysql_fetch_assoc($result))// to make the data repeated
  {
  ?>
    <td><? echo $r['remarks' ];?></td>
  	<td><? echo $r['remarks1'];?></td>
    <td><? echo $r['remarks2'];?></td>
    <td><? echo $r['remarks3'];?></td>
    <td><? echo $r['remarks4'];?></td>	
	<?
	}
	?>
</table>
<p class="style3">&nbsp;</p>

</body>
</html>

please help...thanks in advanced

esukf

What does you database struture look like?

Looking at your html table, your voucher and details table should be a one to one relationship. If so, you should use a LEFT JOIN if you want to return every thing on the voucher table. On your details table you should have a voucherid column with refers to the id value of the voucher in the voucher table.

<?
  include "db1.php";
  $sql="SELECT * FROM voucher LEFT JOIN details ON voucher.id = details.voucherid";
  $result=mysql_query($sql)or die(mysql_error());
  while($r=mysql_fetch_assoc($result))// to make the data repeated
  {
  ?>
  <tr>
    <td><span class="style5"><? echo $r['t_id'];?></span></td>
    <td><? echo $r['purpose'];?></td>
    <td><? echo $r['prepare_by'];?></td>
    <td><? echo $r['remarks' ];?></td>
      <td><? echo $r['remarks1'];?></td>
    <td><? echo $r['remarks2'];?></td>
    <td><? echo $r['remarks3'];?></td>
    <td><? echo $r['remarks4'];?></td>    

    <?
    }
    ?>
</table>

chinna

nope it doesnt help me....actually the data displayed but in single line...let say i have 5 data 10 field...so it displayed 50 times in single line...

HalfaBee

you are missing a </tr>