get the value from derived table
in the walikelas table i have field :id_teacher,name,password
in the kelas table i have field :id_class, class_name, and id_teacher.
$query=("SELECT w.name, k.id_teacher, k.class_name FROM walikelas w, kelas k WHERE w.id_teacher = k.id_teacher");
my question is how we get the value from w.name,k.id_teacher,k.class_name and then we can put it in the variabels. Thank you.