$dbhost="localhost"; $u="am12107"; $p="smt0mm4a"; $lpp=10; $type="abris"; if (isset($pa)==0): $pa=0; endif; $pg=$pa*$lpp; $pg=intval($pg); mysql_connect($dbhost,$u,$p); $rb=mysql($u,"select * from bandeau where dest='abris'"); $nb=mysql_numrows($rb); $ib=0; $texte=mysql_result($rb,$ib,"texte"); $rt=mysql($u,"select * from presentation where dest='abris'"); $nt=mysql_numrows($rt); $it=0; $titre1=mysql_result($rt,$it,"titre1"); $titre2=mysql_result($rt,$it,"titre2"); $presentation1=mysql_result($rt,$it,"presentation1"); $presentation2=mysql_result($rt,$it,"presentation2"); $presentation3=mysql_result($rt,$it,"presentation3"); $presentation4=mysql_result($rt,$it,"presentation4"); $presentation5=mysql_result($rt,$it,"presentation5"); $presentation6=mysql_result($rt,$it,"presentation6"); $presentation7=mysql_result($rt,$it,"presentation7"); $presentation8=mysql_result($rt,$it,"presentation8"); $presentation9=mysql_result($rt,$it,"presentation9"); $presentation10=mysql_result($rt,$it,"presentation10"); $photo1=mysql_result($rt,$it,"photo1"); $photo2=mysql_result($rt,$it,"photo2"); $photo3=mysql_result($rt,$it,"photo3"); $sql=""; $rsql="select * from produits "; if ($type!=""): if ($sql!=""):$sql=$sql."AND ";endif; $sql=$sql."type like '$type'"; endif; if ($sql!=""): $sql="where ".$sql; endif; $rsql=$rsql.$sql; ;$rsql=$rsql."LIMIT $pg,$lpp"; $r=mysql($u,$rsql); $n=mysql_num_rows($r); $r2=mysql($u,"select count(*)as nb from produits ".$sql); $n2=mysql_result($r2,0,"nb"); $nbp=($n2/$lpp)+1; $i=0; ?>
LES SERVICES A LA CARTE Conçus pour une économie maximum, les services à la carte permettent de s'adapter aux possibilités de chacun. Tarifs, nous consulter.
|