Well im trying to grab some data from a mysql database using the Distinct function in my statement. Thing is, When I try to echo out the reults nothing shows up. but two rows in a table are shown.
there are oonly two records in the databse for testing and the field im looking at are diffrent
<!--Start OS ORDER-->
<?
$os_ord_sql = "SELECT DISTINCT Serial_Platform FROM serialbase";
$os_ord_sql_result = mysql_query($os_ord_sql, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$os_ord_count = mysql_num_rows($os_ord_sql_result);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
// Get Record From Database -------Start-------
while ($os_ord_row = mysql_fetch_array($os_ord_sql_result)){
?>
<tr>
<td><li><? print $os_ord_row["Serial_Product"]; ?></li></td>
</tr>
<?
}
// Get Record From Database -------End-------
?>
</table>
<!--End OS ORDER-->
