1/10 Turffirata
$members = mysql_query("
SELECT DISTINCT t1.transponder_id,t2.firstname,t2.lastname FROM $track AS t1
JOIN members AS t2 ON (t1.transponder_id = t2.transponder_id) ORDER by t2.lastname,t2.firstname ASC;
");
$javascript_item = array();
$item = 0;
while ($row = mysql_fetch_assoc($members)) {
if($row['firstname']){
$javascript_tags[$item++] = $row['transponder_id']." ".$row['lastname']." ".$row['firstname'];
}else{
$javascript_tags[$item++] = $row['transponder_id'];
}
}
?>