Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 不建立外键，不用表连接，怎么查询两个关联表的数据

不建立外键，不用表连接，怎么查询两个关联表的数据

WBOY
Release： 2016-06-13 12:19:51
Original
1652 people have browsed it

不建立外键，不用表连接，如何查询两个关联表的数据
查询两个有关联的数据表，一个表是cate分类表，另一个是game游戏表，分类表的id=game表的cate_id ,不用表连接，不建立外键，怎么将game表的数据和cate表的数据一一对应查出来。
求答
------解决思路----------------------
遍历 cate
  按 cate.id=game.cate_idgame 的条件查询 game

Related labels：
game id nbsp
source：php.cn
Previous article：网站使用qq第三方登录时，自动检测登录正常，手工输入密码再登录，就报 100010 的异常 Next article：PHP执行CMD命令解决方案
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1284
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template