include "header.inc.php";
$type = $_REQUEST[type];
$reqmenu = "SELECT title FROM menu WHERE type='".$type."' LIMIT 0,1";
$resmenu = mysql_query($reqmenu);
$menu_title_ref = @mysql_fetch_array($resmenu);
$reqlangtitle = "SELECT text FROM locs WHERE reflang='" . ($_SESSION['lang']) . "' AND ref='" . $menu_title_ref[title] . "' LIMIT 0,1";
$reslangtitle = mysql_query($reqlangtitle);
$enreglangtitle = @mysql_fetch_array($reslangtitle);
$menu_title= stripslashes ($enreglangtitle[text]);
@mysql_free_result($reslangtitle);
?>
$reqprod = "SELECT * FROM prod WHERE type='".$type."' ORDER BY id desc";
$resprod = mysql_query($reqprod);
$Ncur = 0; // n° de la fiche courante
$Ndeb=@$_REQUEST["num"]; // 1ère fiche transmise par l'URL
while (($enregprod = @mysql_fetch_array($resprod)) && ($Ncur<$conf_maxline+$Ndeb))
{
if($Ncur>=$Ndeb)
{
$prod_id=($enregprod["id"]);
$prod_title_ref= stripslashes ($enregprod["title"]);
$prod_text_ref=stripslashes ($enregprod["text"]);
$prod_picture= stripslashes ($enregprod["picture"]);
$prod_type= stripslashes ($enregprod["type"]);
$prod_price_ref= stripslashes ($enregprod["price"]);
$prod_state_ref= stripslashes ($enregprod["state"]);
$prod_url_ref= stripslashes ($enregprod["url"]);
$reqlangtitle = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$prod_title_ref."' LIMIT 1";
$reslangtitle = mysql_query($reqlangtitle);
$enreglangtitle = @mysql_fetch_array($reslangtitle);
$prod_title= stripslashes ($enreglangtitle["text"]);
@mysql_free_result($reslangtitle);
$reqlangtext = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$prod_text_ref."' LIMIT 1";
$reslangtext = mysql_query($reqlangtext);
$enreglangtext = @mysql_fetch_array($reslangtext);
$prod_text=stripslashes ($enreglangtext["text"]);
@mysql_free_result($reslangtext);
$reqlanglink = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$prod_url_ref."' LIMIT 1";
$reslanglink = mysql_query($reqlanglink);
$enreglanglink = @mysql_fetch_array($reslanglink);
$prod_url=stripslashes ($enreglanglink["text"]);
@mysql_free_result($reslanglink);
$reqlangprice = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$prod_price_ref."' LIMIT 1";
$reslangprice = mysql_query($reqlangprice);
$enreglangprice = @mysql_fetch_array($reslangprice);
$prod_price=stripslashes ($enreglangprice["text"]);
@mysql_free_result($reslangprice);
$reqlangstate = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$prod_state_ref."' LIMIT 1";
$reslangstate = mysql_query($reqlangstate);
$enreglangstate = @mysql_fetch_array($reslangstate);
$prod_state=stripslashes ($enreglangstate["text"]);
@mysql_free_result($reslangstate);
if ($prod_picture!='')
{
$picturepath = getPicturePath ($prod_picture,"prod");
$size = resizePicture ($picturepath, 200);
$width = $size["width"];
$height = $size["height"];
$realwidth = $size["realwidth"];
$realheight = $size["realheight"];
$tnpicturepath = getPicturePath (("tn_".$prod_picture),"prod");
$tspicturepath = getPicturePath (("ts_".$prod_picture),"prod");
};
?>
echo $prod_title; ?> |
if ($prod_picture!='')
{
?>
}
?>
|
echo $prod_url; ?> |
echo $prod_text; ?> |
if (($prod_price !='') || ($prod_state != ''))
{
?>
echo $prod_price; ?> |
echo $prod_state; ?> |
};
if ($prod_price !='')
{
?>
|
};
?>
};
$Ncur++;
}
pagecount($Ndeb, $conf_maxline, $Ncur, $resprod, $enregprod, "&type=".$type);
@mysql_free_result($resprod);
?>
include "bottom.inc.php"; ?>