> $sql2_results = mysql_fetch_array($top_level); I guess this must be in a loop otherwise your $sq12_results keep getting overwitten; thus, the last record will be shown at the end.
> $query_sql2_rows = mysql_num_rows($top_level); > > echo $query_sql2_rows; > // echo's 2 rows > > print "<table style=\"font-family:Verdana; font-size:10pt\" border=0 > cellpadding=4 width=90%>"; > > print "<tr bgcolor=\"#c0c0c0\"><th width=50>Action ID</th><th > width=100>Owner</th><th width=250>Technology</th><th>Summary</th></tr>"; > > for ($counter=0; $counter < $query_sql2_rows; $counter++) { > $tabledata = mysql_fetch_array($top_level); > echo "<td>$tabledata[0]</td>"; > echo "<td>$tabledata[6]</td>"; > echo "<td>$tabledata[2]</td>"; > echo "<td>$tabledata[3]</td>"; > echo "</tr>"; > } > print "</table>"; > > Thanks. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- i18n Engineer SCO, Inc. www.sco.com (801) 765-4999 x5647 355 South 520 West, Suit 100, Lindon, Utah 84042 USA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php