如何在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[^]