rmeeuwsen Posted October 27, 2008 Share Posted October 27, 2008 I'm trying to build a webpage in php with a listing of all available projects. Every project can involve multiple documents which can be downloaded. The listing contains simply the projectname and a count of all documents which belong to the project: Projectname - (5) documents For the projects and documents I use 2 different tables: tbl_projects ---------------- project_id name description tbl_documents --------------------- document_id project_id name path What do the SQL statement and the php code look like to eventually build the listing? Thanks in advance! Robin Meeuwsen Link to comment https://forums.phpfreaks.com/topic/130276-projects-and-message-count/ Share on other sites More sharing options...
revraz Posted October 27, 2008 Share Posted October 27, 2008 Post what you have done Link to comment https://forums.phpfreaks.com/topic/130276-projects-and-message-count/#findComment-675598 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.