PHP PDO MYSQL JOIN

Question

I have a table called cms_page in which each page has an ID. I want to pull all the information from this table and all the information from cms_page_part table where page_id is equal to the ID i send to the page...confusing i know but here is my attempt:

require '../../config.php';
$conn = new PDO(DB_DSN, DB_USER, DB_PASS);

$id = (int)$_GET['id'];
//$q = $conn->query("SELECT * FROM cms_page WHERE id=$id"); 
$q = $conn->query("SELECT cms_page.id, cms_page.title, cms_page.slug, cms_page_part.* FROM cms_page LEFT JOIN cms_page_part ON cms_page_part.page_id=cms_page.id WHERE cms_page.id = $id"); 

$project = $q->fetch(PDO::FETCH_ASSOC);

Any help figuring out how to join these would be appreciated.

Answer 1

SELECT id, title, slug, cms_page_part.* FROM cms_page JOIN cms_page_part ON cms_page.id = cms_page_part.page_id WHERE cms_page.id=$id

Edited to give you an idea of what I said in my comment.

Do something like...

SELECT * FROM cms_page WHERE id=1 LIMIT 1

Then check to see if the query returned a result, if it doesn't then there is no point in trying to find "parts" now is there?

Do another query with SELECT * FROM cms_page_parts WHERE page_id=1 and then you'll have all the "parts" you need to use within that page. Hopefully that answers your question.

Answer 2

$q = $conn->query("SELECT cms_page.id, cms_page.title, cms_page.slug, cms_page_part.* FROM cms_page LEFT JOIN cms_page_part ON cms_page_part.page_id=cms_page.id WHERE cms_page.id = $id");