There are a 100 ways to do this, but without a display of your code, it's no use. So show the code you are using now.
Ronald :cool:
Here is my code....... It is supposed to come out in this letter and only the last entrys information needs to be filled in.The select part surely is wrong also coz I select * from the table not sure how to pu it .Thanx
<?
$username="root";
$password="issasql";
$database="assets";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM product";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
print '<b>I '.$issued_to.' hereby acknowledge full responsibilty for the equipment
listed below. I acknowledge and fully understand that I will be held
liable for any loss or damage (Software, Hardware or both) cuased to the
equipment whilst in my possession.
In the case of theft, loss or damage, I understand that I will be responsible for
replacing the equipment lost, stolen or damage at their going
market price.
This equipment should be returned in the original condition as recieved.</b><br><br>
<tr> <tr>
<td> <td>
TRANSFERED FROM</b><br><br> TRANSFERED TO</b><br><br>
Responsible Person:</b><br><br> Responsible Person:</b><br><br>
Section:</b><br><br> Section:</b><br><br>
Signature:</b><br><br> Signature:</b><br><br>
Date:</b><br><br></td></tr> Date:</b><br><br></td></tr>';
$i=0;
while ($i < $num) {
$description=mysql_result($result,$i,"description" );
$serial_number=mysql_result($result,$i,"serial_num ber");
$unique_dept_num=mysql_result($result,$i,"unique_d ept_num");
$issued_to=mysql_result($result,$i,"issued_to");
$issued_from=mysql_result($result,$i,"issued_from" );
$section=mysql_result($result,$i,"section");
$issue_date=mysql_result($result,$i,"issue_date");
$return_date=mysql_result($result,$i,"return_date" );
echo "<b>Description :$description </b><br>Serial Number:$serial_number</b><br>Unique Department Number:$unique_dept_num<br>Issued To: $issued_to<br>Issued From: $issued_from<br>Employee Section: $section<br>Date of Issue: $issue_date<br>Return Date: $return_date<hr><br>";
$i++;
}
?>