0 GROUP BY arucikk_id ORDER BY hanyszor $irany LIMIT $mettol, $laponkent";
$sql = "SELECT arucikk_id, sum(db) as hanydarab FROM kosar WHERE rendeles_id>0 GROUP BY arucikk_id ORDER BY hanydarab $irany LIMIT $mettol, $laponkent";
$eredmeny = mysql_query($sql);
while ($sor=mysql_fetch_array($eredmeny)) {
$arucikk_id = $sor["arucikk_id"];
if ($mitkeres=="") {
$sql = "SELECT * FROM arucikk WHERE id=$arucikk_id AND $katszuro";
}
else {
if ($leirasban==1) {
$sql = "SELECT * FROM arucikk WHERE (nev LIKE '%$mitkeres%' OR nev2 LIKE '%$mitkeres%' OR rovidnev LIKE '%$mitkeres%' OR leiras LIKE '%$mitkeres%' OR hosszu_leiras LIKE '%$mitkeres%') AND id=$arucikk_id AND $katszuro";
}
else {
$sql = "SELECT * FROM arucikk WHERE (nev LIKE '%$mitkeres%' OR nev2 LIKE '%$mitkeres%' OR rovidnev LIKE '%$mitkeres%') AND id=$arucikk_id AND $katszuro";
}
}
$eredm = mysql_query($sql);
if (mysql_num_rows($eredm)>0) {
$egysor=mysql_fetch_array($eredm);
$id = $egysor["id"];
$nev = $egysor["nev"];
$nev2 = $egysor["nev2"];
$foto = $egysor["foto"];
$raktaron = $egysor["raktaron"];
$leiras = $egysor["leiras"];
$ar_huf = $egysor["ar_huf"];
$egyseg = $egysor["egyseg"];
?>
|
[ részletesebb tájékoztató... ]
|
|