php - 关于引号的 SQL 查询错误

Question

我在 php 中运行以下查询:

$link = $_GET['link'];
$query = "SELECT DISTINCT sub_category FROM phonebook ORDER BY sub_category WHERE category = '$link' "; 
echo $query;
$sql = mysql_query($query) or die(mysql_error());

它给出了以下错误:

SELECT DISTINCT sub_category FROM phonebook ORDER BY sub_category WHERE category = 'Administration' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE category = 'Administration'' at line 1

如果有的话，我无法理解引号中的错误是什么？

Answer 1

尝试以下操作:

$query = "SELECT DISTINCT sub_category FROM phonebook ORDER BY sub_category WHERE category = '$link' ";

进入

$query = "SELECT DISTINCT sub_category FROM phonebook WHERE category = '".$link."' ORDER BY sub_category ";

你犯了错误“sub_caregory”:

$query = "SELECT DISTINCT sub_caregory FROM phonebook WHERE category = '".$link."' ORDER BY sub_caregory ";