'$jourdui' ORDER BY debut DESC"; //echo $req_rech; $res_rech = mysqli_query($con,$req_rech) ; $cb = mysqli_num_rows($res_rech); //echo $cb; if ($cb > 1) {$s = "S";} if ($cb > 0) {echo "

CURRENT EXHIBITIONS

";} $g=1; while ($guy = mysqli_fetch_array($res_rech)) { $exdes = $guy["description"]; if($guy["img"]) {$affiche = "/artwork/g-".$guy2["img"];} else {$affiche ="/TS-REF/favicon.png";} if(strlen($exdes)>360) {$exdes = substr($exdes,0,357)."... read more";} //$expo = "".ucfirst($guy["nom"])."

(".magiedesdates($guy["debut"],$guy["fin"]).")

".$exdes."

"; $expo = "

".ucfirst($guy["nom"])."

".magiedesdates($guy["debut"],$guy["fin"])."

"; $gr++; //if($gr==2 or $gr==4) { $deckexp .= '

';} //if($gr==3 or $gr==6) { $deckexp .= '

';} //if($gr==4 or $gr==8) { $deckexp .= '

';} $deckexp .= $expo; $expo=""; } echo "".$deckexp.'

'; //if ($cb > 0) {echo "

";} $deckexp =""; $req_rech2 ="SELECT id, nomclean, nom, debut, fin, img, description FROM `exposition` WHERE debut > '$jourdui' ORDER BY debut DESC"; //echo $req_rech2; $res_rech2 = mysqli_query($con,$req_rech2) ; $cb = mysqli_num_rows($res_rech2); if ($cb > 1) {$s = "S";} //echo $cb; if ($cb > 0) {echo "

UPCOMING EXHIBITIONS

";} while ($guy2 = mysqli_fetch_array($res_rech2)) { $exdes = $guy2["description"]; if($guy2["img"]) {$affiche = "/artwork/g-".$guy2["img"];} else {$affiche ="/TS-REF/favicon.png";} if(strlen($exdes)>360) {$exdes = substr($exdes,0,357)."... read more";} //$expo = "".ucfirst($guy["nom"])."

(".magiedesdates($guy["debut"],$guy["fin"]).")

".$exdes."

"; $expo = "

".ucfirst($guy2["nom"])."

".magiedesdates($guy2["debut"],$guy2["fin"])."

"; $gr++; //if($gr==2 or $gr==4) { $deckexp .= '

';} //if($gr==3 or $gr==6) { $deckexp .= '

';} //if($gr==4 or $gr==8) { $deckexp .= '

';} $deckexp .= $expo; $expo=""; } echo "".$deckexp.'

'; $deckexp =""; $req_rech ="SELECT id, nomclean, nom, debut, fin, img, description FROM `exposition` WHERE fin < '$jourdui' ORDER BY debut DESC"; //echo $req_rech; $res_rech = mysqli_query($con,$req_rech) ; $cb = mysqli_num_rows($res_rech); if ($cb > 1) {$s = "S";} //echo $cb; if ($cb > 0) {echo "

PAST EXHIBITION$s

";} while ($guy = mysqli_fetch_array($res_rech)) { $exdes = $guy["description"]; if($guy["img"]) {$affiche = "/artwork/g-".$guy["img"];} else {$affiche ="/TS-REF/favicon.png";} if(strlen($exdes)>360) {$exdes = substr($exdes,0,357)."... read more";} //$expo = "".ucfirst($guy["nom"])."

(".magiedesdates($guy["debut"],$guy["fin"]).")

".$exdes."

"; $expo = "

".ucfirst($guy["nom"])."

".magiedesdates($guy["debut"],$guy["fin"])."

"; $gr++; //if($gr==2 or $gr==4) { $deckexp .= '

';} //if($gr==3 or $gr==6) { $deckexp .= '

';} //if($gr==4 or $gr==8) { $deckexp .= '

';} $deckexp .= $expo; } echo "".$deckexp.'

'; ?>