System by PA5DX
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);
?>
| # | Call | Name | ".$operators[$i].""; } ?>Award | |
|---|---|---|---|---|
| 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 " |
CALL, $operators) >= $min_calls) { ?>
|