Meerdere variabelen in $_GET

SELECT id, titel, prijs, foto1, datum FROM advertenties WHERE hcat = '1' AND scat = '3' AND mcat = '6' OR hcat = '4' AND scat = '3' AND mcat = '6' ORDER BY datum DESC

SELECT id, titel, prijs, foto1, datum FROM advertenties WHERE hcat = '1' AND scat = '3' AND mcat = '6' OR hcat = '4' AND scat = '3' AND mcat = '6' ORDER BY datum DESC

$_GET['hcat'] // levert 1,4
$_GET['scat'] // levert 3
$_GET['mcat'] // levert 6

$_GET['hcat'] // levert 1,4
$_GET['scat'] // levert 3
$_GET['mcat'] // levert 6

SELECT id, titel, prijs, foto1, datum FROM advertenties WHERE hcat = '11' AND hcat '12' AND scat = '17' AND mcat = '24' ORDER BY datum DESC

SELECT id, titel, prijs, foto1, datum FROM advertenties WHERE hcat = '11' AND hcat '12' AND scat = '17' AND mcat = '24' ORDER BY datum DESC

<?php
$query = 'SELECT id, titel, prijs FROM advertenties '; 
$queryPart = 'WHERE ( %s ) ORDER BY datum DESC'; 
$queryWhere = array(); 

if(isset($_POST['hcat'])) { 
    $hcat = array_map( 'mysql_real_escape_string', $_POST['hcat'] ); 
    $queryWhere[] = '( hcat IN ( '.implode(', ', $hcat) . ' ) )'; 
} 


if(isset($_POST['scat'])) { 
    $scat = array_map( 'mysql_real_escape_string', $_POST['scat'] ); 
    $queryWhere[] = '( scat IN ( '.implode(', ', $scat) . ' ) )'; 
}

if(isset($_POST['mcat'])) { 
    $mcat = array_map( 'mysql_real_escape_string', $_POST['mcat'] ); 
    $queryWhere[] = '( mcat IN ( '.implode(', ', $mcat) . ' ) )'; 
} 

if(isset($_POST['mtcat'])) { 
    $mtcat = array_map( 'mysql_real_escape_string', $_POST['mtcat'] ); 
    $queryWhere[] = '( mtcat IN ( '.implode(', ', $mtcat) . ' ) )'; 
} 

if(isset($_POST['stcat'])) { 
    $stcat = array_map( 'mysql_real_escape_string', $_POST['stcat'] ); 
    $queryWhere[] = '( stcat IN ( '.implode(', ', $stcat) . ' ) )'; 
} 
 
if(isset($_POST['klcat'])) { 
    $klcat = array_map( 'mysql_real_escape_string', $_POST['klcat'] ); 
    $queryWhere[] = '( klcat IN ( '.implode(', ', $klcat) . ' ) )'; 
} 
 

$query .= sprintf($queryPart, implode(' AND ', $queryWhere)); 


$result = mysql_query( $query ); 
?>

<?php
$query = 'SELECT id, titel, prijs FROM advertenties '; 
$queryPart = 'WHERE ( %s ) ORDER BY datum DESC'; 
$queryWhere = array(); 
 
if(isset($_POST['hcat'])) { 
    $hcat = array_map( 'mysql_real_escape_string', $_POST['hcat'] ); 
    $queryWhere[] = '( hcat IN ( '.implode(', ', $hcat) . ' ) )'; 
} 
 
 
if(isset($_POST['scat'])) { 
    $scat = array_map( 'mysql_real_escape_string', $_POST['scat'] ); 
    $queryWhere[] = '( scat IN ( '.implode(', ', $scat) . ' ) )'; 
}
 
if(isset($_POST['mcat'])) { 
    $mcat = array_map( 'mysql_real_escape_string', $_POST['mcat'] ); 
    $queryWhere[] = '( mcat IN ( '.implode(', ', $mcat) . ' ) )'; 
} 
 
if(isset($_POST['mtcat'])) { 
    $mtcat = array_map( 'mysql_real_escape_string', $_POST['mtcat'] ); 
    $queryWhere[] = '( mtcat IN ( '.implode(', ', $mtcat) . ' ) )'; 
} 
 
if(isset($_POST['stcat'])) { 
    $stcat = array_map( 'mysql_real_escape_string', $_POST['stcat'] ); 
    $queryWhere[] = '( stcat IN ( '.implode(', ', $stcat) . ' ) )'; 
} 
 
if(isset($_POST['klcat'])) { 
    $klcat = array_map( 'mysql_real_escape_string', $_POST['klcat'] ); 
    $queryWhere[] = '( klcat IN ( '.implode(', ', $klcat) . ' ) )'; 
} 
 
 
$query .= sprintf($queryPart, implode(' AND ', $queryWhere)); 
 
 
$result = mysql_query( $query ); 
?>

if() {

} elseif() {

} elseif() {

} else() {

}

if() {
 
} elseif() {
 
} elseif() {
 
} else() {
 
}

<?php
$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'"; 
$resulttest = mysql_query($querytest);  

while($row = mysql_fetch_assoc($resulttest)) { 
   $link = 'http://www.dsf.nl/dfs/design/zoek.php?hcat=' . $row['id']; 
   if(isset($_GET['hcat'])) { 
      $link .= ',' . $_GET['hcat'];
   } 
   if(isset($_GET['scat'])) { 
      $link .= '&amp;scat=' . $_GET['scat']; 
   } 
   if(isset($_GET['mcat'])) { 
      $link .= '&amp;mcat=' . $_GET['mcat']; 
   } 
   echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />'; 
} 
?>

<?php
$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'"; 
$resulttest = mysql_query($querytest);  
 
while($row = mysql_fetch_assoc($resulttest)) { 
   $link = 'http://www.dsf.nl/dfs/design/zoek.php?hcat=' . $row['id']; 
   if(isset($_GET['hcat'])) { 
      $link .= ',' . $_GET['hcat'];
   } 
   if(isset($_GET['scat'])) { 
      $link .= '&amp;scat=' . $_GET['scat']; 
   } 
   if(isset($_GET['mcat'])) { 
      $link .= '&amp;mcat=' . $_GET['mcat']; 
   } 
   echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />'; 
} 
?>

<?php
$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'"; 
$resulttest = mysql_query($querytest);  

$aCats = array('h', 's', 'm'); // h vooraan


while($row = mysql_fetch_assoc($resulttest)) { 
   $link = 'http://www.dsf.nl/dfs/design/zoek.php?'; 
   foreach($aCats AS $id => $sCat){
       if(isset($_GET[$sCat.'cat']) || $id == 0){
             if(isset($_GET[$sCat.'cat'])){
	         $aSelectedCats = explode(",", $_GET[$sCat.'cat']);
             } else {
	         $aSelectedCats = array();
	     }
           if($id == 0){ // hcat  
               if(!in_array($row['id'], $aSelectedCats)){
                   $aSelectedCats[] = $row['id'];
               }  
           } else {
               $link .= "&";
           }
	     $link .= $sCat.'cat=';     
           $link .= implode(",", $aSelectedCats);
       }
   }
   echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />'; 
} 
?>

<?php
$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'"; 
$resulttest = mysql_query($querytest);  
 
$aCats = array('h', 's', 'm'); // h vooraan
 
 
while($row = mysql_fetch_assoc($resulttest)) { 
   $link = 'http://www.dsf.nl/dfs/design/zoek.php?'; 
   foreach($aCats AS $id => $sCat){
       if(isset($_GET[$sCat.'cat']) || $id == 0){
             if(isset($_GET[$sCat.'cat'])){
	         $aSelectedCats = explode(",", $_GET[$sCat.'cat']);
             } else {
	         $aSelectedCats = array();
	     }
           if($id == 0){ // hcat  
               if(!in_array($row['id'], $aSelectedCats)){
                   $aSelectedCats[] = $row['id'];
               }  
           } else {
               $link .= "&";
           }
	     $link .= $sCat.'cat=';     
           $link .= implode(",", $aSelectedCats);
       }
   }
   echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />'; 
} 
?>

$var1 = $_POST["zoekveld1"];
$var2 = $_POST["zoekveld2"];

AND scat = '".$var1."' OR scat = '".$var2."'

$var1 = $_POST["zoekveld1"];
$var2 = $_POST["zoekveld2"];
 
AND scat = '".$var1."' OR scat = '".$var2."'

<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);

$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'";
$resulttest = mysql_query($querytest);

$aCats = array('hcat', 'scat', 'mcat');

while($row = mysql_fetch_assoc($resulttest)) 
{
    $link = 'zoek.php';
    $sign = '?';
    foreach($aCats AS $id => $sCat)
    {
        $aSelectedCats = (isset($_GET[$sCat])) ? explode(",", $_GET[$sCat]) : array();
        $aSelectedCats = ($id == 0 and count($aSelectedCats) == 0) ? array($row['id']) : $aSelectedCats;
        if(isset($_GET[$sCat]))
        {
            if(in_array($row['id'], $aSelectedCats))
            {
                unset($aSelectedCats[array_search($row['id'], $aSelectedCats)]);
            }
            else
            {
                $aSelectedCats[] = $row['id'];
            }
        }
        if(count($aSelectedCats) > 0)
        {
            $link .= $sign . $sCat . '=' . implode(",", $aSelectedCats);
            $sign = '&';
        }
    }
    echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />';
}
?> 

<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
 
$querytest = "SELECT id, naam FROM categorie WHERE cat = '1'";
$resulttest = mysql_query($querytest);
 
$aCats = array('hcat', 'scat', 'mcat');
 
while($row = mysql_fetch_assoc($resulttest)) 
{
    $link = 'zoek.php';
    $sign = '?';
    foreach($aCats AS $id => $sCat)
    {
        $aSelectedCats = (isset($_GET[$sCat])) ? explode(",", $_GET[$sCat]) : array();
        $aSelectedCats = ($id == 0 and count($aSelectedCats) == 0) ? array($row['id']) : $aSelectedCats;
        if(isset($_GET[$sCat]))
        {
            if(in_array($row['id'], $aSelectedCats))
            {
                unset($aSelectedCats[array_search($row['id'], $aSelectedCats)]);
            }
            else
            {
                $aSelectedCats[] = $row['id'];
            }
        }
        if(count($aSelectedCats) > 0)
        {
            $link .= $sign . $sCat . '=' . implode(",", $aSelectedCats);
            $sign = '&';
        }
    }
    echo '<a href="' . $link . '">' . $row['naam'] . '</a><br />';
}
?>