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).

Recommended Answers

All 2 Replies

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 for diafol

use a LEFT JOIN

Be a part of the DaniWeb community

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