MySQL根据变量从表中选择[重复]

Question

This question already has an answer here:

• PHP Variable in Select Statement 7 answers

I have the following problem:
I am trying to select a result from a MySQL database table, depending on the category value:

$sql = mysql_query("SELECT * FROM products WHERE category='garniture' ORDER BY date_added DESC LIMIT 2");   

The problem is that I don't want to use a static value for category (like 'garniture'), but I want this to be determined by a variable value (let's say that variable is $category). How can I manage this?

</div>

Answer 1

Without getting into the fact that you should not be using the MySQL Library anymore, use MySQLi or PDO instead, you would insert a variable in that string as such:

$sql = mysql_query("SELECT * FROM products WHERE category='$category' ORDER BY date_added DESC LIMIT 2");

Or if you find it easier to read:

$sql = mysql_query("SELECT * FROM products WHERE category='" . $category . "' ORDER BY date_added DESC LIMIT 2");