thomas...
Thanks!! worked like a charm.
In case you still want it... here is the code.
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
//Get appropriate tracklisting
$rresult = mysql_query("SELECT * FROM xxxx WHERE showdate= '$DateResult'");
//Count Rows (should always be 1)
$num=mysql_numrows($result);
$i=0;
while($i<$num)
{
$showdate=mysql_result($result,$i,"showdate");
$track1_1=mysql_result($result,$i,"track1_1");
$track1_2=mysql_result($result,$i,"track1_2");
$track1_3=mysql_result($result,$i,"track1_3");
$track1_4=mysql_result($result,$i,"track1_4");
$track1_5=mysql_result($result,$i,"track1_5");
$track1_6=mysql_result($result,$i,"track1_6");
$track1_7=mysql_result($result,$i,"track1_7");
$track1_8=mysql_result($result,$i,"track1_8");
$track1_9=mysql_result($result,$i,"track1_9");
$track1_10=mysql_result($result,$i,"track1_10";
$track1_11=mysql_result($result,$i,"track1_11");
$track1_12=mysql_result($result,$i,"track1_12");
$track2_1=mysql_result($result,$i,"track2_1");
$track2_2=mysql_result($result,$i,"track2_2");
$track2_3=mysql_result($result,$i,"track2_3");
$track2_4=mysql_result($result,$i,"track2_4");
$track2_5=mysql_result($result,$i,"track2_5");
$track2_6=mysql_result($result,$i,"track2_6");
$track2_7=mysql_result($result,$i,"track2_7");
$track2_8=mysql_result($result,$i,"track2_8");
$track2_9=mysql_result($result,$i,"track2_9");
$track2_10=mysql_result($result,$i,"track2_10");
$track2_11=mysql_result($result,$i,"track2_11");
$track2_12=mysql_result($result,$i,"track2_12");
++$i;
}
//Close the Database
mysql_close();
?>
<? //BEGIN LOOP FOR HOUR 1 ?>
<td valign="top"><p><font size="2" face="Geneva, Arial, Helvetica, sans-serif">
<? $hour1count=1;
while ($hour1count<13) {
echo "$hour1count . ";
$currentvalue = '$track1'.$hour1count;
echo ${"track1".$hour1count};
echo "<br>";
$hour1count++;
}
?>