mysql计入PHP变量

像这样：

// Changed the query - there's no need for DISTINCT// and aliased the count as "num"$data = mysql_query('SELECt COUNT(`users_id`) AS num FROM `users_table`') or die(mysql_error());// A COUNT query will always return 1 row// (unless it fails, in which case we die above)// Use fetch_assoc for a nice associative array - much easier to use$row = mysql_fetch_assoc($data);// Get the number of uses from the array// 'num' is what we aliased the column as above$numUsers = $row['num'];