if ($belepve==1) {
?>
|
|
}
else {
?>
|
}
?>
A kosr tartalma
|
Utoljra megtekintett termkek
if ($belepve==1) {
$sql = "SELECT * FROM megtekintve WHERE ugyfel_id=$webshop_id ORDER BY mikor DESC LIMIT 0,5";
}
else {
$sql = "SELECT * FROM megtekintve WHERE session_id='" . session_id() . "' ORDER BY mikor DESC LIMIT 0,5";
}
$eredmeny = mysql_query($sql);
while ($sor=mysql_fetch_array($eredmeny)) {
$cid = $sor["arucikk_id"];
$parancs = "SELECT * FROM arucikk WHERE id=$cid";
$rs = mysql_query($parancs);
$egysor = mysql_fetch_array($rs);
$cnev = $egysor["nev"];
$chuf = $egysor["ar_huf"];
$cfoto = $egysor["foto"];
?>
 |
|
|
HUF
|
kosrba
|
}
?>
|
Legnpszerbb termkek
$sql = "SELECT arucikk_id, sum(db) as hanydarab FROM kosar WHERE rendeles_id>0 GROUP BY arucikk_id ORDER BY hanydarab DESC LIMIT 0, 10";
$eredmeny = mysql_query($sql);
while ($sor=mysql_fetch_array($eredmeny)) {
$cid = $sor["arucikk_id"];
$parancs = "SELECT * FROM arucikk WHERE id=$cid";
$rs = mysql_query($parancs);
$egysor = mysql_fetch_array($rs);
$cnev = $egysor["nev"];
$chuf = $egysor["ar_huf"];
$cfoto = $egysor["foto"];
?>
 |
|
|
HUF
|
kosrba
|
}
?>
|