\$sql $sql")); $vataantal = mysql_num_rows($result); $sql = "SELECT id FROM bier WHERE category = 'bier' AND keywords NOT LIKE '%vat%' $not;"; $result = @mysql_query($sql,$connection) or die(report_error(__FILE__,__LINE__,mysql_errno(),mysql_error(),"\$sql $sql")); $flesaantal = mysql_num_rows($result); $bieren = "$flesaantal bieren op fles, $vataantal van 't vat"; // Whisky MALT $sql = "SELECT id FROM bier WHERE category = 'whisky' AND type = 'malt' $not;"; $result = @mysql_query($sql,$connection) or die(report_error(__FILE__,__LINE__,mysql_errno(),mysql_error(),"\$sql $sql")); $maltaantal = mysql_num_rows($result); // Whisky blend $sql = "SELECT id FROM bier WHERE category = 'whisky' AND type = 'blend' $not;"; $result = @mysql_query($sql,$connection) or die(report_error(__FILE__,__LINE__,mysql_errno(),mysql_error(),"\$sql $sql")); $blendaantal = mysql_num_rows($result); // JENEVER $sql = "SELECT id FROM bier WHERE category = 'jenever' $not;"; $result = @mysql_query($sql,$connection) or die(report_error(__FILE__,__LINE__,mysql_errno(),mysql_error(),"\$sql $sql")); $jeneveraantal = mysql_num_rows($result); $sql = "SELECT * FROM geschiedenis where id = '1'"; $result = @mysql_query($sql,$connection) or die(report_error(__FILE__,__LINE__,mysql_errno(),mysql_error(),"\$sql $sql")); while ($row = mysql_fetch_array($result)) { $tekst = $row['tekst']; $img1 = $row['img1']; } $tekst = nl2br($tekst); $tekst = str_replace('&','&',$tekst); $tekst = str_replace('[$flesaantal]',$flesaantal,$tekst); $tekst = str_replace('[$vataantal]',$vataantal,$tekst); $tekst = str_replace('[$maltaantal]',$maltaantal,$tekst); $tekst = str_replace('[$blendaantal]',$blendaantal,$tekst); $tekst = str_replace('[$jeneveraantal]',$jeneveraantal,$tekst); ?> Geschiedenis / History
logo
adres illustratie