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