php - 前端查询和 PHP SQL 语句

Question

我正在尝试从站点提交查询以从 MySQL 数据库检索某些记录。当我从站点表单执行查询时，当我知道它不为空时，我得到 mysql_error() 返回“无效查询:查询为空”。

$Level = $_POST['level'];
$Year  = $_POST['year'];
$Name  = $_POST['name'];
$Award  = $_POST['award'];

$query = mysql_query("SELECT *
    FROM wineawards
    WHERE LEVEL = $Level
      OR YEAR = $Year
      OR name = $Name
      OR award = $Award

    ");

$result = mysql_query($query);

不确定我是否在这里遗漏了某些内容，或者输入了错误的内容？

Answer 1

$query = mysql_query("SELECT *
    FROM wineawards
    WHERE LEVEL = '$Level'
      OR YEAR = '$Year'
      OR name = '$Name'
      OR award = '$Award'

    ");

$result = mysql_query($query);