DATE_SUB(CURRENT_DATE, INTERVAL 75 DAY),1,0) as new, ref_perso, ref_collecte, comment_fr as comment from plantes left join genre on genre.id=plantes.genre left join espece on espece.id=plantes.espece left join variete on variete.id=plantes.variete"; $sql_count="select count(*) from plantes left join genre on genre.id=plantes.genre left join espece on espece.id=plantes.espece left join variete on variete.id=plantes.variete"; //*************construction de la clause where********************* $oper=""; $sql2=""; $dt_photo="0000-00-00"; $dt_semis="0000-00-00"; $order_by=" order by genre,espece,variete,ref_perso"; if($genre!="") { $sql2.=$oper."plantes.genre=".$genre; $oper=" and "; } if($espece!="") { $sql2.=$oper."plantes.espece in (".$espece.")"; $oper=" and "; } if($variete!="") { $sql2.=$oper."plantes.variete=".$variete; $oper=" and "; } if($ref_perso!="") { $sql2.=$oper."ref_perso like '%".$ref_perso."%'"; $oper=" and "; } if($ref_collecte!="") { $sql2.=$oper."ref_collecte like '%".$ref_collecte."%'"; $oper=" and "; } if($localisation!="") { $sql2.=$oper."localisation like '%".$localisation."%'"; $oper=" and "; } if($new_only=="yes") { $sql2.=$oper.'date_photo > DATE_SUB(CURRENT_DATE, INTERVAL 75 DAY)'; $oper=" and "; } if($to_sell=="yes") { $sql2.=$oper.'prix>0'; $oper=" and "; } if($photo_mm!="") { $sql2.=$oper."month(date_photo)".$dt_photo_choix."'".$photo_mm."'"; $oper=" and "; } if($photo_aaaa!="") { $sql2.=$oper."year(date_photo)".$dt_photo_choix."'".$photo_aaaa."'"; $oper=" and "; } if($semis_mm!="") { $sql2.=$oper."month(date_semis)".$dt_semis_choix."'".$semis_mm."'"; $oper=" and "; } if($semis_aaaa!="") { $sql2.=$oper."year(date_semis)".$dt_semis_choix."'".$semis_aaaa."'"; $oper=" and "; } if($sql2!="") { $sql.=" where ".$sql2; $sql_count.=" where ".$sql2.";"; } $sql.=$order_by; if(!$nbr_result) $nbr_result=5; if(!$offset_result) $offset_result=0; $q_limit=$offset_result.",".$nbr_result; $sql.=" limit ".$q_limit.";"; $res_count=mysql_query($sql_count) or die("impossible de compter le nombre de resultats : ".$sql_count); $count=mysql_fetch_row($res_count); $res=mysql_query($sql) or die("la requete de recherche a echoue : ".$sql); ?>

		"); } ?> ".strval($i+1)." "):print(" ".strval($i+1)." "); $separ="|"; } print("   \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" \n"); print(" \n"); print("\n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print(""):print($val['variete']."\n"); print("\n"); print(" genre \n"); print("espèce \n"); print("variété ".$val['genre']." \n"); print($val['espece']." \n"); $val['variete']==""?print("- \n"); print(" \n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" localisation \n"); print("date semis \n"); print("date photo "); $val['localisation']==""?print("-"):print(htmlentities($val['localisation'])); print(" \n"); $val['date_semis']=="0000-00-00"?print("-"):print(substr($val['date_semis'],8,2)."/".substr($val['date_semis'],5,2)."/".substr($val['date_semis'],0,4)); print(" \n"); print(substr($val['date_photo'],8,2)."/".substr($val['date_photo'],5,2)."/".substr($val['date_photo'],0,4)); print(" \n"); print(" \n"); print(" \n"); print(" \n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print(" notre réf. ".htmlentities($val['ref_perso'])." réf. "); print("collecte \n"); $val['ref_collecte']==""?print("-"):print(htmlentities($val['ref_collecte'])); print(" \n"); print(" \n"); print(nl2br($val['comment'])); $val['new'] || $val['prix']>0?print(" "):""; $val['prix']>0?print(" ".$val['prix']." € "):""; $val['new']?print(""):""; print(" \n"); print("     \n"); } ?>
".strval($i+1)." "):print(" ".strval($i+1)." "); $separ="|"; } } elseif($to_sell=="yes") { print("Nous ne vendons pas de plantes durant la période hivernale (octobre - mars)."); } else print("La recherche n'a produit aucun résultat."); ?>
• nouvelle recherche • classement genres-espèces