<?php

$sql = "SELECT * FROM cimkek_hirek LEFT JOIN hirek
    ON cimkek_hirek.hir_id=hirek.id WHERE cimkek_hirek.cimke_id='" . $cimke_id. " ORDER BY hirek.id ASC'";

    mysql_query("SET NAMES 'utf8'");
    mysql_query("SET CHARACTER SET 'utf8'");
    if (!mysql_query($sql, $con)) {
        die('Error: ' . mysql_error());
    }

    $eredmeny = mysql_query($sql);

    while($sor = mysql_fetch_array($eredmeny)){
        $id = $sor["id"];
        $hir = $sor["hir"];
        $hir_nev = $sor["hir_nev"];
        $hir_bevezeto = $sor["hir_bevezeto"];
        $datum = $sor["datum"];

        $tomb = array (
                       "tipus" => "hir",
                       "id" => $id,
                       "hir" => $hir,
                       "hir_nev" => $hir_nev,
                       "hir_bevezeto" => $hir_bevezeto,
                       "datum" => $datum
                       );
        array_push($teszt,$tomb);
    }

    ?>