我得到了这个:
$orderby = 'name'; //'$_GET['orderby']' <---- I'd like to use this later to make it dynamic$req = mysql_query('select id, name, year, genre, cover from table ORDER BY `table`.`'$orderby'` A
我对15000条记录运行了这个查询FROM `User` `t` INNER JOIN ON t.countryCode = c.countryCode
WHERE (userType != -1 AND userType != 1 AND address1 IS NOT NULL AND zip IS NOT NULL AN