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

在我的类别表中,我确保它指向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 = "<table>";                       //PRints out table
$str .= "<td>" ."Title" . "</td>";      //First row
$str .= "<td>" ."Reference" . "</td>";  //N row...
$str .= "<td>" ."Salary(£)" . "</td>";
$str .= "<td>" ."Description" . "</td>";
$str .= "<td>" ."Category" . "</td>";
foreach ($results as $row) {
    $ref = $row['reference'];
    $link = "<form method='get' action='apply.PHP' name='edit'>
         <input tyPE='hidden' name='referenceNumber' value='$ref'>
         <input type='submit' value='$ref'>
    </form>";
    $str .= "<tr>";
    $str .= "<td>" . $row['title'] . "</td>";
    $str .= "<td>" . $row['reference'] . "</td>";
    $str .= "<td>" . $row['salary'] . "</td>";
    $str .= "<td>" . $row['description'] . "</td>";
    $str .= "<td>" . $row['category'] . "</td>";
    $str .= "<td> " .$link . "</td>";
    $str .= "</tr>";
}
$str .= "</table>";
echo $str;
}

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

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