php - 运行我的代码时出现以下错误

Question

当我运行这段代码时，它向我显示了以下错误:-

where 子句中的“virtuemart_product_id”列不明确谁能告诉我如何解决它。谢谢。

<?php
    mysql_connect('localhost','root','');
    mysql_select_db('joom');
    $get=$_GET['virtuemart_product_id'];
    $get1=$_GET['virtuemart_category_id'];
    $sql="SELECT 
            btn9c_virtuemart_products_en_gb.virtuemart_product_id,
            btn9c_virtuemart_products_en_gb.product_s_desc, 
            btn9c_virtuemart_products_en_gb.product_desc, 
            btn9c_virtuemart_products_en_gb.product_name, 
            btn9c_virtuemart_product_prices.product_price 
          FROM btn9c_virtuemart_products_en_gb 
          JOIN btn9c_virtuemart_product_prices ON
            btn9c_virtuemart_products_en_gb.virtuemart_product_id=btn9c_virtuemart_product_prices.virtuemart_product_id 
          WHERE virtuemart_product_id='$get' ";
    if($result=mysql_query($sql))
    {
        while($row=mysql_fetch_assoc($result))
        {
            echo $row['product_price'];
        }
    }
    else 
    {
        echo (mysql_error());
    }       
?>

Answer 1

将表名(或别名)和列名放在 where 子句中，这在您要连接的表之间是通用的。

尝试以下:

$sql="SELECT 
        btn9c_virtuemart_products_en_gb.virtuemart_product_id,
        btn9c_virtuemart_products_en_gb.product_s_desc, 
        btn9c_virtuemart_products_en_gb.product_desc, 
        btn9c_virtuemart_products_en_gb.product_name, 
        btn9c_virtuemart_product_prices.product_price 
      FROM btn9c_virtuemart_products_en_gb 
      JOIN btn9c_virtuemart_product_prices ON
        btn9c_virtuemart_products_en_gb.virtuemart_product_id=btn9c_virtuemart_product_prices.virtuemart_product_id 
      WHERE  btn9c_virtuemart_products_en_gb.virtuemart_product_id='$get' ";