在一个页面有四条sql ,数据库为mysql5.1
$rs1 = $db->query("select id ,material_id,material_name,material_status_id,fee_pay from media_material_map where subject_id=241 order by sortrank desc limit 0,$pagenum");while($row=$db->fetch_array($rs1)){
echo '<a href="view1.php?id='.$row['material_id'].'"></a>';
}
// 影视
$rs2 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=250 order by sortrank desc limit 0,$pagenum");while($row=$db->fetch_array($rs2)){
echo '<a href="view2.php?id='.$row['material_id'].'"></a>';
}// 娱乐八卦 $rs3 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=243 order by sortrank desc limit 0,5");
while($row=$db->fetch_array($rs3)){
echo '<a href="view3.php?id='.$row['material_id'].'"></a>';
}
// 综艺节目 $rs4 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=244 order by sortrank desc limit 0,5");
while($row=$db->fetch_array($rs4)){
echo '<a href="view4.php?id='.$row['material_id'].'"></a>';
}可以合并成一条sql吗? 并且分别循环得出各栏目下的资源?不同的栏目使用不用页面view1.php view2.php view3.php view4.php
$rs1 = $db->query("select id ,material_id,material_name,material_status_id,fee_pay from media_material_map where subject_id=241 order by sortrank desc limit 0,$pagenum");while($row=$db->fetch_array($rs1)){
echo '<a href="view1.php?id='.$row['material_id'].'"></a>';
}
// 影视
$rs2 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=250 order by sortrank desc limit 0,$pagenum");while($row=$db->fetch_array($rs2)){
echo '<a href="view2.php?id='.$row['material_id'].'"></a>';
}// 娱乐八卦 $rs3 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=243 order by sortrank desc limit 0,5");
while($row=$db->fetch_array($rs3)){
echo '<a href="view3.php?id='.$row['material_id'].'"></a>';
}
// 综艺节目 $rs4 = $db->query("select id ,material_id,material_name,cp_id,material_status_id,fee_pay from media_material_map where subject_id=244 order by sortrank desc limit 0,5");
while($row=$db->fetch_array($rs4)){
echo '<a href="view4.php?id='.$row['material_id'].'"></a>';
}可以合并成一条sql吗? 并且分别循环得出各栏目下的资源?不同的栏目使用不用页面view1.php view2.php view3.php view4.php
解决方案 »
- MySQL建立一个ODBC系统数据源
- 一个分组更新的sql语句如何写?
- 对表A插入一条数据,再取得刚插入的数据的ID号插入B表
- 请问:table1表中的number记录了table2中的记录数,当table2加删记录时, 怎样用SQL语句更新这个number
- mysql的where条件过滤时是先执行前面的判断语句还是后面的判断语句!
- 数据库和网页不在一个服务器,对速度有没有影响啊?
- 关于一个企业电子商务的数据同步问题
- 关于批量insert 问题
- 已经按月分表后的流水表,数据量还是很大,要生成统计信息,该怎么优化
- mysql 主从同步的几个疑问
- 求救高人!INSERT command denied to user 'mydb'@'192.1.169.2'
- mysql存储过程参数长度问题
or
直接用UNION ALL
echo '<a href="view4.php?id='.$row['material_id'].'"></a>';//循环这里 不同的栏目使用不同的模版页面,有四个栏目,能否用一条或两条sql 把查询的结果放到四个数组里,
}