0) { $orderstring = " order by ".mysql_real_escape_string($_GET['orderby'])." ".$direction." "; } else { $orderstring = " ORDER BY aantal desc, NAME desc"; } if(strlen($_GET['zoekstring']) > 0) { $wherestring = " WHERE `CALL` like '%".mysql_real_escape_string($_GET['zoekstring'])."%' OR NAME LIKE '%".mysql_real_escape_string($_GET['zoekstring'])."%' OR OPERATOR LIKE '%".mysql_real_escape_string($_GET['zoekstring'])."%' OR COUNTRY LIKE '%".mysql_real_escape_string($_GET['zoekstring'])."%'"; } $sql = $sql." ".$wherestring." group by `CALL` ".$orderstring; $result = mysql_query($sql) or die (mysql_error()); $c=1; $aantal = mysql_num_rows($result); ?>
".$operators[$i].""; } ?> COUNTRY).".png")) { $vlag = "COUNTRY).".png\">"; } else { $vlag = ""; } ?> CALL."' "; $uitvoeren2 = mysql_query($sql2); $aantal = mysql_result($uitvoeren2,0); if($aantal > 0) { $plaatje = "nav_plain_green.png"; } else { $plaatje = "nav_plain_red.png"; } echo ""; } ?>
# Flag Call Name Country Your QSL Card
CALL;?> NAME;?> COUNTRY;?> CALL, $operators) >= count($operators)) { ?>