php 主表附表,php – 使用主表引用子表

在我的数据库中,我有一个作业表,你可以说它是我数据库中的主表.我有一个名为category的列,此列指向一个名为category的表,该表包含不同的类别.

拿起外键的概念,我把列类别变成了一个外键,它查看了类别表.

在我的类别表中,我确保它指向ID.

当我运行我的网页时,它打印出类别列中的值1,理论上它应该不打印“Driving”？

function getJobDetails($job,$cat){

//this connects to the database

include "connectToDatabse.php";

//show me the results from job, where category is like cat vice versa

$results = $pdo->query("SELECT * FROM job WHERE category LIKE '$cat%' OR title LIKE '$job'");

$str = "

$str .= "

" ."Title" . ""; //first row

$str .= "

" ."Reference" . ""; //N row...

$str .= "

" ."Salary(£)" . "";

$str .= "

" ."Description" . "";

$str .= "

" ."Category" . "";

foreach ($results as $row) {

$ref = $row['reference'];

$link = "

";

$str .= "

";

$str .= "

" . $row['title'] . "";

$str .= "

" . $row['reference'] . "";

$str .= "

" . $row['salary'] . "";

$str .= "

" . $row['description'] . "";

$str .= "

" . $row['category'] . "";

$str .= "

" .$link . "";

$str .= "

";

}

$str .= "

";

echo $str;

}

上面的代码是一个返回作业表中数据的函数.

编辑：引用问题,因为categories列指向类别表,它是否应该将数据引回到作业表？