= $query->fetch_array()){
$candidate_id=$row['candidate_id'];
$sql = "SELECT *, candidate.id AS canid FROM candidate LEFT JOIN positions ON positions.id=candidates.id ORDER BY positions.id ASC";
?>
<td><?php echo $row ['position'];?></td>
Try select * FROM candidate c join position p on c.id = p.candidates order by
Обсуждают сегодня