So than would this…
<table border="0" class="crewtables" id="alternate2">
<tr>
<th nowrap="nowrap">Name</th>
<th>Rank</th>
<th>Status</th>
</tr>
<?php do { ?>
<tr>
<td nowrap="nowrap"><?php echo $row_RS_Lawrence_Midshipman['ProductName']; ?></td>
<td><?php echo $row_RS_Lawrence_Midshipman['ProductShortDesc']; ?></td>
<td><?php echo ($row_RS_Lawrence_Midshipman['Sold'])?"Sold":"Available"; ?></td>
</tr>
<?php } while ($row_RS_Lawrence_Midshipman = mysql_fetch_assoc($RS_Lawrence_Midshipman)); ?>
</table>
Become this?
<table border="0" class="crewtables" id="alternate2">
<tr>
<th nowrap="nowrap">Name</th>
<th>Rank</th>
<th>Status</th>
</tr>
<?php do { ?>
<tr>
<td nowrap="nowrap"><a href="store/products_detail.php?ProductID=<?php echo($row_Recordset['ProductID']); ?>"><?php echo $row_RS_Lawrence_Midshipman['ProductName']; ?></a></td>
<td><?php echo $row_RS_Lawrence_Midshipman['ProductShortDesc']; ?></td>
<td><?php echo ($row_RS_Lawrence_Midshipman['Sold'])?"Sold":"Available"; ?></td>
</tr>
<?php } while ($row_RS_Lawrence_Midshipman = mysql_fetch_assoc($RS_Lawrence_Midshipman)); ?>
</table>