我有一个允许用户在其中运行查询的表。但是,在我的系统中,我允许用户在表上运行查询,然后使用相同的查询结果运行另一个查询。employees WHERE jobTitle = 'Sales Rep'以前使用SQLite语法,我能够通过将这两个查询操作到SELECT * FROM (SELECT * FROM employees WHERE jobTitle = '
where buildingname='$id' ORDER BY floorno ASC LIMIT $from, $max_results "; $result = mysql_query("SET NAMES utf8"); //the main trick
$result = mysql_query($query) or die(mysql_error());$rows = mysql_num