Your Location is: Home > Php
inner join for two tables with foreign key
Question
what im trying to do is something like this:
i have sql:
$kursantai = "kursantai";
$seminaras = "seminaras";
$sql = "SELECT `{$this->kursantai}`.`vardas`,
`{$this->seminaras}`.`pavadinimas`
FROM `{$this->seminaras}`
INNER JOIN `{$this->$kursantai}`
ON `{$this->$kursantai}`.`seminaro_nr` = `{$this->seminaras}`.`sem_id`
ORDER BY `{$this->seminaras}`.`pavadinimas`";
how can i print my sql results in a way that is shown in picture?