SQL Related Projects

[dee19802000]

How would i create an sql statement for related items in my database?  I have tried this but it isnt dynamic enough because not all sections have education as a related topic

SELECT *
FROM projects
WHERE p_id LIKE '%Education%'

Any help would be appreciated.

 

Dee

 

 

[Maq]

You're going to have to elaborate, this doesn't make sense to me.

[dee19802000]

Ok, its like projects that are related to another, These should be related by client, category and type of project.  So when a user clicks on a project they will see projects that are related by those elements above in a scrolling box.  This is my prototype at the minute

 

http://2b.selfip.com/2bv4/project-details.php?cp_id=2&p_id=2

 

Dee

 

 

[ignace]

Post your database structure

[dee19802000]

see image attached.

 

 

 

[attachment deleted by admin]

[Maq]

Assuming categories is how you would like to group, you're going to have to join 'projects' and 'project_categories' ON 'cp_id' -> 'c_id'.

[dee19802000]

I have that done already, do i need to use a WHERE or LIKE statement to relate them?

 

 

[Maq]

I have that done already, do i need to use a WHERE or LIKE statement to relate them?

 

 

 

For example, if the "Education" category id is 2, you would JOIN the tables like so:

 

SELECT * FROM projects p LEFT JOIN project_categories pc ON p.cp_id = pc.c_id WHERE p.cp_id = 2