");
echo("
");
echo("");
echo("");
echo("");
echo " ";
echo("");
echo("Ce mois-ci dans Fluvial");
echo "";
echo(" | ");
$row15 = trim($row[15]);
$row16 = trim($row[16]);
if($row15<>"" OR $row16<>"")
{
echo("");
echo("");
echo("Pour en savoir plus sur ce loueur : ");
if($row15<>"") echo("- ".$row15."
");
if($row16<>"") echo("- ".$row16."
");
echo(" ");
echo(" | ");
}
echo("
");
echo("");
}
?>
Adresse
$row9 = trim($row[9]);
if($row9<>"") echo($row9."
");
?>
$row10 = trim($row[10]);
if($row10<>"") echo($row10."
");
?>
$row11 = trim($row[11]);
if($row11<>"") echo($row11."
");
?>
$row12 = trim($row[12]);
if($row12<>"") echo($row12." - ".$row[13]);
?>
$row14 = trim($row[14]);
if($row14<>"") echo("Téléphone : ".$row14."
");
?>
Bateaux proposés à la location
$table_location_bateau = 'bateau_loc_tarif';
$table_bateau = 'bateau';
$bateaux_cles=array();
for($i=31;$i<=56;$i++) {
if(!$row[$i]) {continue;}
$bateaux_cles[]=$row[$i];
}
$query_location_bateau = "SELECT *, bateau.CLE as BAT_CLE_BAT FROM $table_location_bateau tarif LEFT JOIN $table_bateau bateau ON bateau.CLE = tarif.CLE_BATEAU WHERE CLE_LOUEUR=$cle ";
if( count($bateaux_cles) ) {
$query_location_bateau = "SELECT *, bateau.CLE as BAT_CLE_BAT FROM $table_bateau WHERE bateau.CLE in (".implode(",",$bateaux_cles).") ORDER BY bateau.MODELE";
}else {
$query_location_bateau .= ' AND 0 ';
$query_location_bateau .= ' GROUP BY tarif.CLE_BATEAU ORDER BY bateau.MODELE';
}
if(!$result_lb=mysql_query($query_location_bateau))
echo "Erreur de la requête : ".mysql_error();
else{
$count=1;
$numcolonne=1;
$nb_ligne_max = 10;
while($row_lb=mysql_fetch_array($result_lb)){
if($drap==0) { $drap=1; }
if($row_lb['FICHEACTIVE']==1){
$lien_start = '
';
$lien_end = '';
}else{
$lien_start = '';
$lien_end = '';
}
${'HTML_liste'.$numcolonne} .= '
'.$lien_start.stripslashes($row_lb['MODELE']).$lien_end.'';
if ($count<$nb_ligne_max) {$count++;}
else {$count=1; $numcolonne++;}
}
}
if ($HTML_liste1!='') {$HTML_liste1='
';}
if ($HTML_liste2!='') {$HTML_liste2='
';}
if ($HTML_liste3!='') {$HTML_liste3='
';}
if ($HTML_liste4!='') {$HTML_liste4='
';}
?>
=$HTML_liste1?> |
=$HTML_liste2?> |
=$HTML_liste3?> |
=$HTML_liste4?> |
Modalités
Location à la semaine,
if($row[20]==1) echo("2 semaines et plus, ");?>
pour des
if($row[21]==1) echo("allers-retours à la base."); else echo("allers simple.");?>
if($row[18]==1) echo("Week-end et "); if($row[19]==1) echo("Mini-semaine");?>
/*if($row[18]<>0 OR $row[19]<>0) echo(" possible hors saison.");*/?>
$row22 = trim($row[22]);
if($row22<>"") echo("
Aller simple pour ".stripslashes($row22)."");
?>
$count=1;
$numcolone=1;
$nb_ligne_max = 4;
$HTML_liste1 = '';
$HTML_liste2 = '';
$HTML_liste3 = '';
if($row[5]<>0)
{
$table2="voienav";
$query2="SELECT * FROM $table2 where cle=$row[5]";
$result2 = MYSQL_QUERY($query2,$id);
$row2=MYSQL_FETCH_ROW($result2);
${'HTML_liste'.$numcolone} .= "
$row2[4] ";
if ($count<$nb_ligne_max) {$count++;}
else {$count=1; $numcolone++;}
}
if($row[6]<>0)
{
$table2="voienav";
$query2="SELECT * FROM $table2 where cle=$row[6]";
$result2 = MYSQL_QUERY($query2,$id);
$row2=MYSQL_FETCH_ROW($result2);
//echo("
$row2[4] ");
${'HTML_liste'.$numcolone} .= "
$row2[4] ";
if ($count<$nb_ligne_max) {$count++;}
else {$count=1; $numcolone++;}
}
if($row[7]<>0)
{
$table2="voienav";
$query2="SELECT * FROM $table2 where cle=$row[7]";
$result2 = MYSQL_QUERY($query2,$id);
$row2=MYSQL_FETCH_ROW($result2);
//echo("
$row2[4] ");
${'HTML_liste'.$numcolone} .= "
$row2[4] ";
if ($count<$nb_ligne_max) {$count++;}
else {$count=1; $numcolone++;}
}
for($i=23;$i<=30;$i++)
{
if($row[$i]<>0)
{
if($drap==0) {$drap=1;}
$table2="voienav";
$query2="SELECT * FROM $table2 where cle=$row[$i]";
$result2 = MYSQL_QUERY($query2,$id);
$row2=MYSQL_FETCH_ROW($result2);
//echo("
$row2[4] ");
${'HTML_liste'.$numcolone} .= "
$row2[4] ";
if ($count<$nb_ligne_max) {$count++;}
else {$count=1; $numcolone++;}
}
}
if ($HTML_liste1!='') {$HTML_liste1='
';}
if ($HTML_liste2!='') {$HTML_liste2='
';}
if ($HTML_liste3!='') {$HTML_liste3='
';}
?>
if($row[4]<>0)
{
$table2="voienav";
$query2="SELECT * FROM $table2 where cle=$row[4]";
$result2 = MYSQL_QUERY($query2,$id);
$row2=MYSQL_FETCH_ROW($result2);
echo("Voie principale : $row2[4] ");
}
?>
|
Voies d'eau accessibles en 1 semaine de navigation :
|
=$HTML_liste1?> |
=$HTML_liste2?> |
=$HTML_liste3?> |