rendered paste bodymysql_select_db($database_DAS, $DAS);
$query_rTest = "SELECT * FROM events ORDER by eventDate ASC";
$rTest = mysql_query($query_rTest, $DAS) or die(mysql_error());
$row_rTest = mysql_fetch_assoc($rTest);
$totalRows_rTest = mysql_num_rows($rTest);
mysql_select_db($database_DAS, $DAS);
$query_venueNames = "SELECT venues.venueName, events.eventLocation FROM venues, events WHERE events.eventLocation = venues.venueID";
$venueNames = mysql_query($query_venueNames, $DAS) or die(mysql_error());
$row_venueNames = mysql_fetch_assoc($venueNames);
$totalRows_venueNames = mysql_num_rows($venueNames);
<table>
<tr>
<th>Date</th>
<th>Where</th>
<th>When</th>
<th>Bands</th>
<th>Cost</th>
<th>Notes</th>
</tr>
<?php do { ?>
<tr>
<td class="evdate"><?php echo date('m-d',strtotime($row_rTest['eventDate'])); ?></td>
<td><?php echo $row_venueNames['venueName']; ?></td>
<!-- <td><?php echo $row_rTest['eventLocation']; ?></td> -->
<td><?php echo $row_rTest['eventTime']; ?></td>
<td><a href="<?php echo $row_rTest['band1URL']; ?>"><span class="headliner"><?php echo $row_rTest['band1']; ?></span></a>
<ul>
<?php if ($row_rTest['band2'] != NULL) echo "<li><a href='$row_rTest[band2URL]'> $row_rTest[band2]</a></li>"; ?>
<li><a href='<?php echo $row_rTest['band3URL']; ?>'><?php echo $row_rTest['band3']; ?></a></li>
<?php if ($row_rTest['band4'] != NULL) echo "<li><a href='$row_rTest[band4URL]'> $row_rTest[band4]</a></li>"; ?>
<?php if ($row_rTest['band5'] != NULL) echo "<li><a href='$row_rTest[band5URL]'> $row_rTest[band5]</a></li>"; ?>
<?php if ($row_rTest['band6'] != NULL) echo "<li><a href='$row_rTest[band6URL]'> $row_rTest[band6]</a></li>"; ?>
<?php if ($row_rTest['band7'] != NULL) echo "<li><a href='$row_rTest[band7URL]'> $row_rTest[band7]</a></li>"; ?>
<?php if ($row_rTest['band8'] != NULL) echo "<li><a href='$row_rTest[band8URL]'> $row_rTest[band8]</a></li>"; ?>
<?php if ($row_rTest['band9'] != NULL) echo "<li><a href='$row_rTest[band9URL]'> $row_rTest[band9]</a></li>"; ?>
<?php if ($row_rTest['band10'] != NULL) echo "<li><a href='$row_rTest[band10URL]'> $row_rTest[band10]</a></li>"; ?>
</ul>
</td>
<td><?php echo $row_rTest['eventCost']; ?></td>
<td><?php echo $row_rTest['eventNotes']; ?></td>
</tr>
<?php } while ($row_rTest = mysql_fetch_assoc($rTest)); ?>
</table>