在一个页面有四条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存储过程删除重复数据,高手速度来
- 高分请教PostgreSQL中的集合查询问题
- 一个电脑两个IP,如何启动mysql
- 求救:Mysql安装
- 数据 显示排名
- MYSQL FUNCTION的问题
- 用DELPHI访问MYSQL数据库该怎么办? 有没有简单的方法?
- 各位大虾:问一个奇怪的问题,我在window2000 Prefession 下安装了MySQL4.0,但MySQL好象不能启动,这是为什么??
- 用 Navicat 无法连接Linux服务器上已配置好的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 把查询的结果放到四个数组里,
}