\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); ?>