query("SELECT * FROM vitrin_1 ORDER BY sira ASC", PDO::FETCH_ASSOC);
if($query1->rowCount()){
foreach($query1 as $row1){
?>
query("SELECT
urun.id,
urun.baslik,
urun.sef,
urun.eski_fiyat,
urun.fiyat,
urun_img.img
FROM
vitrin_1_urun
INNER JOIN urun ON vitrin_1_urun.urun_id = urun.id
INNER JOIN urun_img ON urun.id = urun_img.urun_id
WHERE
vitrin_1_urun.vitrin_id = '{$row1['id']}'
GROUP BY
urun_img.urun_id
ORDER BY
vitrin_1_urun.sira ASC
", PDO::FETCH_ASSOC);
foreach($query as $row){
?>
query("SELECT * FROM vitrin ORDER BY sira ASC", PDO::FETCH_ASSOC);
if($query1->rowCount()){
foreach($query1 as $row1){
?>
query("SELECT
urun.id,
urun.baslik,
urun.sef,
urun.eski_fiyat,
urun.fiyat,
urun_img.img
FROM
vitrin_urun
INNER JOIN urun ON vitrin_urun.urun_id = urun.id
INNER JOIN urun_img ON urun.id = urun_img.urun_id
WHERE
vitrin_urun.vitrin_id = '{$row1['id']}'
GROUP BY
urun_img.urun_id
ORDER BY
vitrin_urun.sira ASC
", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){
?>