I currently have the following array setup to display the states that have casting notices with the number of notices printed next to each location:
//display results
$NumRecords = 0;
while(($row = mysql_fetch_array($result)))
{
$NumRecords++;
$VState = $row[\\"State\\"];
//spell out location
if (\\"al\\" == $VState) $VLocation = \\"Alabama\\";
else if (\\"ak\\" == $VState) $VLocation = \\"Alaska\\";
else if (\\"az\\" == $VState) $VLocation = \\"Arizona\\";
...(etc.)
else $VLocation = \\"\\";
print \\"<a href=\\\\"castingresults.php?state=\\" . $row[\\"State\\"] . \\"\\\\">\\" . $VLocation . \\"</a> (\\" . $row[\\"Count\\"] . \\")<br>\\" ;
flush;
} //end of while loop
Which prints like this:
Nevada(4)
New York(32)
Texas(19)
This prints all location on top of each other(seperated by a <br>).
I want to have all the locations printed with 1/4 of them in each column of a table with 4 columns. But I only want the locations that have notices to print with a hyperlink and the number(count) of notices.
I need the locations distributed over four columns so that the user does not need to scroll.
ANY help and suggestion or solutions would be greatly appreciated.
