karatekid36 Posted January 4, 2008 Share Posted January 4, 2008 In the above Image, I drew out an idea I had for a php page I want to build. I have the projects at the top and then the projects listed again at the bottom. Each of the users will have projects assigned to them anywhere from 0 to 20 or so. I know how to list the projects at the top, but my issue is how to get them from the project table and then have the four more recent entries in my project assets table like I have at the bottom. I just designed this figuring that I could figure it out later, but I have hit a road block. There are two tables. The Projects table and the Project Assets table. I am just unsure how to query the table so that I can display them like I have in the bottom of the image. Any guidance would be greatly appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/84396-have-a-design-and-need-help-with-the-php-and-mysql-theory/ Share on other sites More sharing options...
awpti Posted January 4, 2008 Share Posted January 4, 2008 Post your table layout (or PM it to me) and I'll give you a query that should let you cover all of that info in a single query. Quote Link to comment https://forums.phpfreaks.com/topic/84396-have-a-design-and-need-help-with-the-php-and-mysql-theory/#findComment-429873 Share on other sites More sharing options...
karatekid36 Posted January 4, 2008 Author Share Posted January 4, 2008 in the project table... projid - index user1 user2 user3 dateentered creator current The users are the people who are working on the project. It is currently three users, but I want to have it be 20 users. The creator is the user who started the project. current is to show if the project is still being worked on. If it is. It can either be a 0 type 1 deal or a Yes No. projassetid - index projid inresponseto title type userid assign dateentered messagetext This table is a little bit of a mess. The projid is the project it is in reference to. the inresponseto is if it is a comment on a message, this is filled with the proper number. Title is the title. type is either File, Deadline, Comment, or Message. Assign is who the item is assigned to. This generally only applies to deadlines. Userid is who made this project asset. dateentered is dateentered. Messagetext is a description of area. Please let me know if this helps. Quote Link to comment https://forums.phpfreaks.com/topic/84396-have-a-design-and-need-help-with-the-php-and-mysql-theory/#findComment-429902 Share on other sites More sharing options...
karatekid36 Posted January 14, 2008 Author Share Posted January 14, 2008 bump Quote Link to comment https://forums.phpfreaks.com/topic/84396-have-a-design-and-need-help-with-the-php-and-mysql-theory/#findComment-438537 Share on other sites More sharing options...
karatekid36 Posted February 5, 2008 Author Share Posted February 5, 2008 I would still very much be interested in a response to this post. If you have any thoughts feel free to add please. Quote Link to comment https://forums.phpfreaks.com/topic/84396-have-a-design-and-need-help-with-the-php-and-mysql-theory/#findComment-459046 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.