\n"; print "
\n"; print "Un instant svp... le téléchargement des chandelles peut être long!\n"; print "
"; print "Drapeaux
\n"; if($start == "") $start = 1; if($pagelength == "") $pagelength = 24; if($rowlength == "") $rowlength = 8; if($pagelength < $rowlength) $rowlength = $pagelength; $Query = "SELECT c.Chandelle_id,c.Prenom,c.Nom_famille,p.nom,p.logo,c.logo as clogo,c.important FROM Chandelles c, pays p WHERE p.pays_id=c.pays_id "; if($pays_id != "") $Where[] = " c.pays_id=$pays_id "; if($cree_le != "") $Where[] = " c.cree_le='$cree_le' "; if($range_1 != "" && $range_2 != "") $Where[] = " c.cree_le>='$range_1' AND c.cree_le<='$range_2' "; if($logo != "") $Where[] = " c.logo='$logo' "; if($Where) { $Query .= " AND ".join(" AND ",$Where)." "; } $Query .= " order by c.Chandelle_id"; $sth = mysql_db_query($DBname,$Query); if(!$sth) { print "Error querying DB (".mysql_error().")!
"; } else { $numrows = mysql_num_rows($sth); if(($start+$pagelength) > $numrows) $end = $numrows; else $end = (($start-1)+$pagelength); print "\n"; print "\n"; $i = 0; while(($row = mysql_fetch_object($sth)) && ($i < $end)) { if($i < ($start-1)) { $i++; // if(($i+$rowlength) > ($start-1)) { // if($i % $rowlength == 0) {print "\n"; $started=1;} // else if($started) print "\n"; // } continue; } if($showing % $rowlength == 0) { print "\n"; } print "\n"; if($showing % $rowlength == ($rowlength-1)) { print "\n"; } $i++; $showing++; } if($showing % $rowlength != 0) { for ($x = ($showing % $rowlength); $x <= ($rowlength-1); $x++) { print ""; } print "\n"; } print ""; print "

Chandelle #$start à #".$end." de $numrows

clogo; print "\" BORDER=0 WIDTH=43 HEIGHT=80> "; if($row->important == 1) print ""; print $row->Prenom." ".$row->Nom_famille; if($row->important == 1) print ""; print " "; print "logo."\" ALT=\""; print $row->nom."\" BORDER=0 WIDTH=42 HEIGHT=26>

"; print ""; print " "; if($i-(($pagelength-($start-1))*2) >= 0) { if($i-($pagelength*2) < 0) $pi=($pagelength*2); else $pi = $i; print ""; print "Page précédente"; } else print "Page précédente"; print " "; $i++; if($i <= $numrows) { print ""; print "Page suivante"; } else print "Page suivante"; print "

\n"; } include "basdepage.php3"; ?>