php - 页面上的 MySQL 语法错误代码

Question

只是想知道是否有人发现我的错误，我真的看不到它，但我的页面上有从 get_sql 开始的 sql 代码，谢谢

<?
    if (!empty($item_details[$counter]['name'])) {

        $main_image = $db -> get_sql_field("SELECT media_url FROM " . DB_PREFIX . "auction_media WHERE
            auction_id='" . $item_details[$counter],['auction_id'] . "' AND media_type=1 AND upload_in_progress=0 ORDER BY media_id ASC LIMIT 0,1", 'media_url');

        $auction_link = process_link('auction_details', array('name' => $item_details[$counter]['name'], 'auction_id' => $item_details[$counter]['auction_id']));?>

Answer 1

改变

auction_id='" . $item_details[$counter],['auction_id'] . "'

到

auction_id="' . $item_details[$counter]['auction_id'] . '"

这里您需要 " 来覆盖您的字符串而不是 ' 并且逗号可能如 echo_Me 所说