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.
use a LEFT JOIN
