\r\n";
$sqlstr1 = "SELECT x, COUNT(x) AS antal FROM nullfun";
if(is_numeric($alder)) {
$sqlstr1 .= " WHERE alder < $alder";
}
$sqlstr1 .= " GROUP BY x";
$query1 = mysql_query($sqlstr1, $con) or die(mysql_error());
while($row1 = mysql_fetch_array($query1)) {
echo $row1['x'] . ' ' . $row1['antal'] . "
\r\n";
}
echo "Med IF:
\r\n";
$sqlstr2 = "SELECT x, COUNT(x) AS antal FROM nullfun WHERE IF(alder IS NULL OR $alder IS NULL,IF($alder IS NULL,true,false),alder<$alder) GROUP BY x";
$query2 = mysql_query($sqlstr2, $con) or die(mysql_error());
while($row2 = mysql_fetch_array($query2)) {
echo $row2['x'] . ' ' . $row2['antal'] . "
\r\n";
}
mysql_close($con);
?>