set_filenames(array( 'body' => 'photos.html' )); $SELECT = "SELECT * "; $FROM = "FROM propriete_photos LEFT JOIN proprietes ON proprietes.propriete_id = propriete_photos.propriete_id "; if(isset($_GET["id"])){ $json = array(); $id = mysql_real_escape_string($_GET["id"]); $WHERE = "proprietes.dossier = '$id'"; $sql = $SELECT . $FROM . " WHERE " . $WHERE; $q = mysql_query($sql) or die(mysql_error()); $row_ = mysql_fetch_array($q); for($i=1; $i<=21; $i++){ if (!empty($row_['photo'.$i]) && file_exists("images-loc/".$row_['photo'.$i])){ $json[] = "images-loc/".$row_['photo'.$i]; $template->set_block("photos", array( "SRC" => "images-loc/".$row_['photo'.$i] )); } } $template->set("PHOTOSJ", json_encode($json)); $template->set("DOSSIER_TROUVE", true); } else{ $row_ = false; $template->set("DOSSIER_TROUVE", false); } $template->display('body'); ?>