php - 通过 ID 过滤连接两列

Question

我需要连接数据库中的两列，并按 postID 进行过滤，以便我可以使用 URL 参数 postid。下面的代码不起作用，但我不知道如何更改它。有建议吗？

$colname_join = "-1";
if (isset($_GET['postID'])) {
  $colname_join = $_GET['postID'];
}

mysql_select_db($database_connection, $connection);
$query_join = sprintf("SELECT * FROM image inner join post on post.postimage = image.imagename WHERE postID = %s", GetSQLValueString($colname_join, "int"));
$join = mysql_query($query_join, $connection) or die(mysql_error());
$row_join = mysql_fetch_assoc($join);
$totalRows_join = mysql_num_rows($join);

Answer 1

$sql  = "SELECT *
        FROM image
        INNER JOIN post ON post.postimage = image.imagename
        WHERE postID = %s". GetSQLValueString($colname_join, "int")";