如何在php中从一个表获取细节到另一个表?
问题描述:
帮帮我:)我的电子邮件是saurabhkalla1993@gmail.com
help me :) my e-mail is saurabhkalla1993@gmail.com
答
我想你想加入2桌记录
sql查询是这样的
从主表电影中选择并加入来自其他表类型的更多信息
I think you want to join 2 tables records together
The sql query is something like this
select from main table "movie" and join more information from other table "genres"
sql =
SELECT movies.title,genres.name
FROM movies LEFT OUTER JOIN genres
ON movies.gen_id = genres .id
更多信息
https://dev.mysql.com/doc/refman/4.1/en/join.html [ ^ ]
和一个例子e $>
http://www.w3schools.com/sql/sql_join.asp [ ^ ]
MORE INFO
https://dev.mysql.com/doc/refman/4.1/en/join.html[^]
and an example
http://www.w3schools.com/sql/sql_join.asp[^]