Forum PHP.pl

[PHP] pobierz, plaintext 
        $centrala = Array(
                        'Odzial 1' => array (
                                                                array("pracownik_id"=>"33", "name"=>"Zdzichu Zprzesieki", "pesel"=>"************","FZ"=>"Z")
                                                        ),
                        'odzial 2' => array (
                                                                array("pracownik_id"=>"11", "name"=>"Jan Kowalski", "pesel"=>"************","FZ"=>"Z"),
                                                                array("pracownik_id"=>"892", "name"=>"Zuzanna Kiepska", "pesel"=>"************","FZ"=>"S")
                                                        )
        );
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT Odzialy.name AS oddzial,Odzialy.id AS id_odzialu, pracownik.id AS pracownik_id,pracownik.name AS Imie_i_nazwisko, kadry.PESEL AS pesel, kadry.Rodzaj_umowy AS Zatrudnienie
FROM p_users AS centrala
JOIN p_emp_ptc AS PTC ON centrala.id=PTC.cuid
JOIN p_users AS Odzialy ON PTC.puid=Odzialy.id
JOIN p_user_usergroup_map AS map ON Odzialy.id=map.user_id
JOIN p_emp_ptp AS ptp ON Odzialy.id=ptp.pracodawca
JOIN p_users AS pracownik ON pracownik.id=ptp.id
JOIN p_emp_kadry AS kadry ON pracownik.id=kadry.id
WHERE centrala=5002;
[SQL] pobierz, plaintext