Kod
$tpd='products_description';
$tp='products';
$pc='products_to_categories';
$cd='categories_description';
$TabProdukty = $Baza->Take_name("SELECT $cd.categories_name as kategorie, $tp.products_image_lrg as obrazek, $tpd.products_description as opis, $tp.products_id as id_towar, $tpd.products_name as nazwa, $tp.products_price as cena
FROM $tp
INNER JOIN $tpd ON $tp.products_id=$tpd.products_id
INNER JOIN $cd ON $pc.categories_id=$cd.categories_id
LEFT JOIN $ts ON $tp.products_id=$ts.products_id AND status=1
WHERE $tp.products_status=1");
$Baza->Logoff();
$tp='products';
$pc='products_to_categories';
$cd='categories_description';
$TabProdukty = $Baza->Take_name("SELECT $cd.categories_name as kategorie, $tp.products_image_lrg as obrazek, $tpd.products_description as opis, $tp.products_id as id_towar, $tpd.products_name as nazwa, $tp.products_price as cena
FROM $tp
INNER JOIN $tpd ON $tp.products_id=$tpd.products_id
INNER JOIN $cd ON $pc.categories_id=$cd.categories_id
LEFT JOIN $ts ON $tp.products_id=$ts.products_id AND status=1
WHERE $tp.products_status=1");
$Baza->Logoff();