Code-Bin #499

untitled PHP Code
Posted by: attendee_list | February 12, 2010 @ 7:02pm

PHP Code

// Customized Attendee Listing
		echo '<table border="0" cellpadding="0" cellspacing="0">';
// Attendee ID
	$sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
	$result = mysql_query ( $sql );
	while ( $row = mysql_fetch_assoc ( $result ) ) {
		$id = $row ['id'];
		echo "<tr>";
		echo '<td width="25%">';
		echo "$id";
		echo "</td>";
	}
// Attendee Full Name
	$sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
	$result = mysql_query ( $sql );
	while ( $row = mysql_fetch_assoc ( $result ) ) {
		$lname = $row ['lname'];
		$fname = $row ['fname'];
		echo '<td width="25%">';
		echo "$fname $lname";
		echo "</td>";
	}
// Attendee Gamer Tag
	$sql = "SELECT * FROM " . $events_answer_tbl . " WHERE question_id='2'";
	$result = mysql_query ( $sql );
	while ( $row = mysql_fetch_assoc ( $result ) ) {
		$answer = $row ['answer'];
		echo '<td width="25%">';
		echo "$answer";
		echo "</td>";
	}
// Attendee Paid Status
	$sql = "SELECT * FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
	$result = mysql_query ( $sql );
	while ( $row = mysql_fetch_assoc ( $result ) ) {
		$paystatus = $row ['paystatus'];
		echo '<td width="25%">';
		echo "$paystatus";
		echo "</td>";
		echo "</tr>";
	}
		echo "</table>";
}

Syntax Highlighting

[Open in new window]

Author Comments

Trying to have each attendee and their respective data on their own individual table row with each data point in it's own column.

EG.

# Full Name Gamer Tag Paid
1 John Doe fps_john Unpaid
2 Jane Doe fps_jane Paid
3 Billy Doe rts_billy Paid

Rating

4.45 / 8
60 Votes