Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tb_wrapper tb_author
- ================= ==================
- |id| title | url| |id|author|$title|
- ================= ==================
- |1 |titleA |urlA| | 1| A |titleA|
- ================= | 2| B |titleA|
- ===================
- ======================
- |id | content | title|
- ======================
- |1 | contentA|titleA|
- ======================
- $query = mysql_query("SELECT
- tb_wrapper.url,
- tb_wrapper.title,
- tb_author.title,
- tb_author.author,
- tb_doc.content,
- tb_doc.title
- FROM
- tb_doc
- INNER JOIN tb_wrapper ON tb_doc.title = tb_wrapper.title
- INNER JOIN tb_author ON tb_wrapper.title = tb_author.title ");
- SELECT w.url, w.title, a.title, a.authors,
- d.content, d.title
- FROM tb_doc d
- INNER JOIN tb_wrapper w ON d.title = w.title
- INNER JOIN
- (
- SELECT title, GROUP_CONCAT(author SEPARATOR ', ') AS authors
- FROM tb_author
- GROUP BY title
- ) a ON w.title = a.title
Add Comment
Please, Sign In to add comment