MySQL如何将表中的数据直接检索到变量？

That's just my php snippet:

$cookies=$_COOKIE['rwt'];
$user =mysql_query("SELECT user FROM users WHERE cookies='$cookies'");

How can I retrieve data from MySQL table, directly to variable $user?Now I get strange result: Resource id #10

You have to fetch a row from the result handle you get:

$user = mysql_query(blah blah blah);
$row = mysql_fetch_assoc($user);
echo $row['user'];

Without fetching an array you can get a single column value with mysql_result();

$cookies=mysql_real_escape_string($_COOKIE['rwt']);
$userResource =mysql_query("SELECT user FROM users WHERE cookies='{$cookies}'");
$user=mysql_result($userResource,0,"user");