hi there, I'm having trouble with my project, I can't wrap my head around the code. Any help would be greatly appreciated!

in a database you have 2 tables. they look like the following..

table: workflow
columns: id, title, content_id

table: content
columns: id, text

list (echo) all the entries in workflow, whilst joining the corresponding content row to each workflow row (by id).

Refer to this to get an idea.

Join workflow and content on workflow.content_id = content.id

Perform a normal 'select all' statement on the resulting table.

Member Avatar

use a LEFT JOIN

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.