include("db.php");
include("header.php");
if(isset($_GET["cat"])) {
$sql="SELECT * FROM caltek_products WHERE cat_id='".$_GET["cat"]."' ORDER by promocja, firma_id, cena";
$result=mysql_query($sql);
$cat_sql="SELECT * FROM caltek_categories WHERE id='".$_GET["cat"]."'";
$cat_result=mysql_query($cat_sql);
$cat_row= mysql_fetch_array($cat_result);
echo"
| Oferta: ".$cat_row["name"]."
";
$nr=1;
echo"
LP | Produkt | Cena | Stan | Kup | ";
while($row= mysql_fetch_array($result)) {
$pr_sql="SELECT * FROM caltek_producenci WHERE pr_id='".$row["firma_id"]."'";
$pr_result=mysql_query($pr_sql);
$pr_row= mysql_fetch_array($pr_result);
if($row["promocja"]=='0'){
$promocja=" ";
} else {
$promocja='';
}
echo"$nr | $promocja ".$pr_row["pr_nazwa"]."
".$row["name"]." | ".$row["cena"]." zł |  |  |
";
$nr++;
}
echo" ";
}
echo" |
";
include("footer.php");
?>