我希望您能帮忙翻译以下内容:我需要解决一个问题:我需要创建一个表格,其中包含4个不同的MySQL数组的值,例如:
$sql = mysql_query("select * from tbl_work where work_category = 1
ORDER BY note DESC");
$sql2 = mysql_query("select * from tbl_work where work_category = 2
ORDER BY note DESC");
$sql3 = mysql_query("select * from tbl_work where work_category = 3
ORDER BY note DESC");
$sql4 = mysql_query("select * from tbl_work where work_category = 4
ORDER BY note DESC");
我创建了四个数组,每个数组都有:
$find1 = mysql_fetch_array($sql);
$find2 = mysql_fetch_array($sql2);
$find3 = mysql_fetch_array($sql3);
$find4 = mysql_fetch_array($sql4);
现在,我需要做10次,一个包含所有数组值的表格,但需要排序,不重复且并排显示,分成类别。
比如4列,每一列都有work_category
的顺序和不同的值。
谢谢!