php怎么调用两个关联数据表里的数据

2014-01-15 11:37:36 574 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

php+sql创建数据库与数据表使用Wampserver64，php版本7.3.12，数据库服务器MySQL。阅读详情

$query = $db->query("SELECT list_dir,list_id,list_name,list_status FROM ff_list WHERE list_status != 0 ORDER BY list_id ASC LIMIT 0, 30");

while($n = $db->fetch_array($query)) {





$query = $db->query("SELECT vod_name,vod_cid FROM ff_vod WHERE vod_cid in ($n['list_id']) ORDER BY rand() LIMIT 0, 10");

while($m = $db->fetch_array($query)) {



        $z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].$m['vod_name'].'</a></h3></div>';

}

}

怎么双重while调用，或者用其它的调用方法调用达到我相要的效果
ff_list数据表是栏目列表
ff_vod是文章列表
两表的关联字段是：vod_cid=list_id
就是吧ff_list里的所有栏目名称调用出来，然后在栏目名称下面显示10条文章，怎么一次性调用出来，看好多论坛或CMS都可以

例如：
栏目名称：军事新闻
aaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbb
ccccccccccccccccc
ddddddddddddddddd
eeeeeeeeeeeeeeeee

栏目名称：娱乐新闻
ffffffffffffffffff
gggggggggggggggggg
hhhhhhhhhhhhhhhhhh
...........

小弟是菜鸟，麻烦知道的大哥直接给代码，谢谢了

...全文

PHP MySQL 创建数据表本文详细介绍了在PHP环境中使用MySQL创建数据表的方法。通过学习本文，您可以了解到数据表设计、创建SQL语句编写、PHP连接MySQL数据库以及执行SQL语句等方面的知识。在实际开发中，掌握这些技能对提高数据库管理能力具有重要意义。阅读详情

1355529020

基础编程 21,889 成员 140,329 内容

+ 关注 + 加入社区

切换为时间正序

码无边 2014-01-16

打赏
举报

少了一个from


select list_name,vod_name from ff_list,ff_vod 
where vod_cid=list_id 
and list_status != 0
and vod_cid in ($n['list_id']) ORDER BY rand() LIMIT 0, 10

码无边 2014-01-16

打赏
举报

为什么你不把栏目表和文章表关联呢？两张表的关联都已经出来，vod_cid=list_id 整合你的sql


select list_name,vod_name,ff_list,ff_vod 
where vod_cid=list_id 
and list_status != 0
and vod_cid in ($n['list_id']) ORDER BY rand() LIMIT 0, 10

1355529020 2014-01-16

打赏
举报

可以了谢谢~~~

xuzuning 2014-01-16

打赏
举报

$query1 = $db->query("SELECT list_dir,list_id,list_name,list_status FROM ff_list WHERE list_status != 0 ORDER BY list_id ASC LIMIT 0, 30");
while($n = $db->fetch_array($query1)) {
 
 
$query2 = $db->query("SELECT vod_name,vod_cid FROM ff_vod WHERE vod_cid in ($n['list_id']) ORDER BY rand() LIMIT 0, 10");
while($m = $db->fetch_array($query2)) {
 
        $z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].$m['vod_name'].'</a></h3></div>';
}
}

一起混吧 2014-01-16

打赏
举报

$z[]='</div>'; 这样不行么？

1355529020 2014-01-16

打赏
举报

$query1 = $db->query("SELECT list_dir,list_id,list_name,list_status FROM ff_list WHERE list_status != 0 ORDER BY list_id ASC LIMIT 0, 30"); while($n = $db->fetch_array($query1)) { $z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].'</a></h3>'; $query2 = $db->query("SELECT vod_name,vod_cid FROM ff_vod WHERE vod_cid in ($n[list_id]) ORDER BY rand() LIMIT 0, 10"); while($m = $db->fetch_array($query2)) { $z[]='<h3>'.$m['vod_name'].'</h3>'; } $z = $z[].'</div>'; }

1355529020 2014-01-16

打赏
举报

基本解决了最后一小步，版主大哥再帮忙下，试过各种都不行


$query1 = $db->query("SELECT list_dir,list_id,list_name,list_status FROM ff_list WHERE list_status != 0 ORDER BY list_id ASC LIMIT 0, 30");
while($n = $db->fetch_array($query1)) {
   $z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].'</a></h3>';
  
$query2 = $db->query("SELECT vod_name,vod_cid FROM ff_vod WHERE vod_cid in ($n[list_id]) ORDER BY rand() LIMIT 0, 10");
while($m = $db->fetch_array($query2)) {
        $z[]='<h3>'.$m['vod_name'].'</h3>';
  
}
$z = $z[].'</div>';
}

就是要在外层循环结尾处加个</div>,也就是在栏目30个循环后面加个</div> 得到的效果是: '<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].'</a></h3>'.'<h3>'.$m['vod_name'].'</h3>'.'</div>'; '<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].'</a></h3>'.'<h3>'.$m['vod_name'].'</h3>'.'</div>'; 如果这样加外层就把内层的隔断了:$z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$n['list_name'].'</a></h3>'.'</div>'; 如果这样加到内层又每条文章都有个</div>:$z[]='<h3>'.$m['vod_name'].'</h3>'.'</div>'; 像我红色部分这样又有错误不知道问题说明白了吗？版主麻烦，谢谢了！

天涯过客009 2014-01-16

打赏
举报

不会，帮你顶一下

一起混吧 2014-01-16

打赏
举报

$query1 = $db->query("SELECT list_dir,list_id,list_name,list_status FROM ff_list WHERE list_status != 0 ORDER BY list_id ASC LIMIT 0, 30");
while($n = $db->fetch_array($query1)) {
   $z[]='<div class="linkbox"><h3>'.$n['list_name'].'</h3></div>';
  
$query2 = $db->query("SELECT vod_name,vod_cid FROM ff_vod WHERE vod_cid in ($n['list_id']) ORDER BY rand() LIMIT 0, 10");
while($m = $db->fetch_array($query2)) {
  
        $z[]='<div class="linkbox"><h3><a href='."'/".$n['list_dir']."/'>".$m['vod_name'].'</a></h3></div>';
}
}

1355529020 2014-01-16

打赏
举报

2楼的版主大哥，报错啊 syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in

php怎么调用两个关联数据表里的数据

相关推荐