Member Avatar for rom.

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

  • 3 Contributors
  • 2 Replies
  • 116 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for kekkaishi

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.

Edited by kekkaishi because: n/a
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.