从SELECT PHP设置变量

Question

I simply want to define the variable "$read" as whatever its value is in the database. How can I do this?

$read =  "SELECT `read` FROM `users` WHERE `id` = '$id'";

Answer 1

$read = mysql_result(mysql_query("SELECT read FROM users WHERE id = $id"),0);