Who's Attending

$attendanceCount people have signed up to attend $titleEvent, including:

\n"); // New added 7/27/05 kjm - next/previous added because Northstar can't optimize their $&%#^#$% database if(isset($offset)) { $theNext = $offset + 100; $thePrev = $offset - 100; $theOffset = " limit 100 offset $offset"; } else { $theNext = "100"; $thePrev = "0"; $theOffset = " limit 100"; } $theOffset = ""; // Get the raw list, sorted by last name $getPeopleQ = "select first_name, last_name, lugnet_id, city, state, country, url_label, url, bio, email from registration where showpublic = 1 and under18flag <> 1 and active = 1 and e_id = $master_event_id order by last_name {$theOffset}"; $getPeople = mysql_query($getPeopleQ); $attendeeCount = mysql_num_rows($getPeople); if($attendeeCount > 0) { echo("\n"); while($row=mysql_fetch_array($getPeople)) { echo("\n"); if(isset($HTTP_COOKIE_VARS['u_id'])) { echo("\n"); } echo("\n"); if($row['city'] != "" && $row['state'] != "") { $theComma = ", "; } else { $theComma = " "; } echo("\n"); if(trim($row['lugnet_id']) != "") { #echo("\n"); echo("\n"); } else { echo("\n"); } if(trim($row['url']) != "") { if(trim($row['url_label']) != "" && trim($row['url_label']) != "Home Page") { echo("\n"); } else { #echo("\n"); echo("\n"); } } else { echo("\n"); } flush(); } echo("
\"Send{$row['first_name']} {$row['last_name']}{$row['city']}{$theComma}{$row['state']}\"LugnetLugnet Profile{$row['url_label']}\"MyHome Page
\n"); // Now add offset Previous and Next echo("\n"); if($theNext > 100) { echo("\n"); } if($theNext > 0 && $attendeeCount > 100) { echo("\n"); } echo("
Previous 100Next 100
\n"); } ?>