mysql_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>