I've managed to get rather far in my attempts to make this work; however, I've been outsmarted at this point.
I have a table in which i want the headers to appear and the data from the query to fill in below. But my headers continue to appear before each entry which is quite annoying. here is my code tell me what i'mdoing wrong please.
Global $conn;
$strSQL = "Select * from (Select Top 10 * From QuoteRequests Where SalesPersonName = '".$_SESSION['MyUserID']."') x ORDER BY QRID DESC";
$rs = db_query($strSQL,$conn);
while($row=db_fetch_array($rs))
{
?>
<table width="200" border="1" cellspacing="1" cellpadding="1" bgcolor="FFFFFF">
<tr align="center">
<th>QRID</th>
<th>Store Name</th>
<th>Store Number</th>
</tr>
<tr align="center">
<td>
<p><a href="<?="QuoteRequests_view.php?editid1=".$row["QRID"]?>" title="<?=$row["StoreName"]?>"><?=$row["QRID"] ?></a> </td><td> <?=$row["StoreName"] ?> </td><td> <?=$row["StoreNumber"]?></p>
</td>
</tr>
</table>
<?
}
I've tried moving the header items above the while but it didn't work.
