I would take a look at the already available solutions at http://www.hotscripts.com http://php.resourceindex.com (many open source/free)
It may be easier to use (and manipulate) one of these to what you need. I am working on a similar project, since I fond many project management solutions to be confused by too many options. part two the syntax you are looking for is UPDATE Status SET projectstatus='whatever' WHERE projectid = 123; http://www.mysql.com/doc/en/UPDATE.html I'd also recommend picking up this small little book. It's a great intro to the power of SQL and will show you how simple some of the cool things you can do are. http://www.amazon.com/exec/obidos/tg/detail/-/0672321289/103-9983226-8456617 I would also recommend putting all project 'properties' in a single table. what I mean is that you don't need a relational setup for items like status and cost where eah project will only have 'one' (Project A costs $5000 and is 40% complete - next week Project A may cost $6000 and be 50% complete - so just update the fields). It would make more sense, and make building your application simpler if these are in a single table. Relations will make sense for items like 'project notes' which would work something like. table 'notes' project_id | create_date | note | author so now we can store a note and know who wrote it and when they did. this same structure can solve your problem of tying contacts to the project table 'project_contacts' project_id | name | company | address | phone | description and whatever other fields you like... olinux --- Randy Hammons <[EMAIL PROTECTED]> wrote: > I'm new and I'm TOTALLY lost! Why am I here? To > BEGGGGG for help! My > office currently keeps track of our projects via an > excel spreadsheet. We > keep such info as project costing, status, points > oif contact, name, > description, number, last updated, etc... What I > want to do is merge all > that info to a mysql database and generate a front > end to view / update all > applicalbe information via the web with php. Should > be easy enough right? > Should I be looking at a content management system > type of design or should > I just be focusing on form manupliation etc? Any > suggestions as to how I > would design this would be very beneficial. > > Part two. > > Lets say I design this puppy using regular static > forms. My database design > looks (currently and tentatively) like this: > > table projects > columns( projectID(pk) number name > description) > > table Managers > columns ( managerid(pk) managername) > > table Status > columns(projectid(pk) projectstatus) > > > table projectdetails > columns(projectid(pk) projectcompletiondate > projectcost lastupdate) > > now lets say someone is viewing a project with > projectid (1). If they > decide to update the status, we can see that the > status tables primary key > is projectid. If they decide to update the status > could you give me an > example of the sql syntax of how that would be > updated. We can visually see > the key relationship, but what would the syntax look > like? We understand > that status is related to the project via the > projectid, but the database > won't replicate that info automatically. How do I > make something like that > happen? > > Part three. > > Any suggestions on how to keep track of the primary > and alternate points of > contact per project as far as database design is > concerned? > > Thank you for reading this far...look forward to > hearing your responses (if > any ;)). > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
