';
$nbproduct+=1;
}
}
unset($res);
if($nbproduct==0 && !empty($_REQUEST['search'])){
#IF NO SEARCH RESULT, SHOW SAME LIST AS HOMEPAGE
$buffproduct .= " Sorry with didn't find anything containing " . $_REQUEST['search']. ". Maybe you would be interested in these items.
";
#NB ITEM TO SHOW
$sql = "SELECT valeur FROM variables WHERE ID=2";
$res=$conn->query($sql);
$row = $res->fetch_assoc();
$nbitemshomepage=(int)$row["valeur"]/2;
unset($res);
$sql = "SELECT * FROM product WHERE ID>1 AND showitem=1 ORDER BY promotion DESC,newproduct DESC, showhomepage DESC, datecreated DESC, ID DESC LIMIT ".$nbitemshomepage;
$res=$conn->query($sql);
if(!empty($res)){
while ($row = $res->fetch_assoc()) {
#IMAGE
$sql2="SELECT * FROM product_img WHERE productid=" .$row["ID"]. " ORDER BY ordre LIMIT 1";
$res2=$conn->query($sql2);
$row2 = $res2->fetch_assoc();
if(file_exists($path . $row2["filename"]) && !empty($row2["filename"])){
$buffshowimage = "products/tn/" .$row2["filename"];
}else{
$buffshowimage = "no_image_available.jpg";
}
unset($res2);
#PRICE
if($row['price']>0 && $row['specialprice']>0 ){
$buffprice='Price: $' .$row['specialprice']. ' ';
}elseif($row['price']>0){
$buffprice='Price: $' .$row['price']. ' ';
}else{
$buffprice=" ";
}
#NEW ITEM
$newitem='';
if($row['newproduct']==1){
$newitem='
