1. // Customized Attendee Listing
  2. echo '<table border="0" cellpadding="0" cellspacing="0">';
  3. // Attendee ID
  4. $sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
  5. $result = mysql_query ( $sql );
  6. while ( $row = mysql_fetch_assoc ( $result ) ) {
  7. $id = $row ['id'];
  8. echo "<tr>";
  9. echo '<td width="25%">';
  10. echo "$id";
  11. echo "</td>";
  12. }
  13. // Attendee Full Name
  14. $sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
  15. $result = mysql_query ( $sql );
  16. while ( $row = mysql_fetch_assoc ( $result ) ) {
  17. $lname = $row ['lname'];
  18. $fname = $row ['fname'];
  19. echo '<td width="25%">';
  20. echo "$fname $lname";
  21. echo "</td>";
  22. }
  23. // Attendee Gamer Tag
  24. $sql = "SELECT * FROM " . $events_answer_tbl . " WHERE question_id='2'";
  25. $result = mysql_query ( $sql );
  26. while ( $row = mysql_fetch_assoc ( $result ) ) {
  27. $answer = $row ['answer'];
  28. echo '<td width="25%">';
  29. echo "$answer";
  30. echo "</td>";
  31. }
  32. // Attendee Paid Status
  33. $sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
  34. $result = mysql_query ( $sql );
  35. while ( $row = mysql_fetch_assoc ( $result ) ) {
  36. $paystatus = $row ['paystatus'];
  37. echo '<td width="25%">';
  38. echo "$paystatus";
  39. echo "</td>";
  40. echo "</tr>";
  41. }
  42. echo "</table>";
  43. }
  44.