Question for all. I'm creating a database that's tracking projects. It uses MySQL, interfaced through a web browser. Projects have a PIN which is a primary key and have other fields such as manager, completion dates, etc. For reporting features, a user wants the following and I have no idea on how to facilitate it. He will be viewing a report that shows certain fields in a nice table layout. Some of these are updated by other users (ie someone else will change the project manager). I need a method that will flag a certain field or entire row if record has changed since the last time he viewed the report. Here's an example. He views the report on 1/1/2003. Some changes a project manager on 1/5/2003. When he views the report again on 1/10/2003, that record should stand out someway (changing the table row background color or something). If he views the report on 1/15/2003, that record should not stand out. Now I can add in an extra field to mark a date when the record was changed last. The problem is how to track when a user last clicked on a hyperlink that executed my select statement. I just thought of adding an updated statement to a field called 'LastViewed', which would enter in a date when he viewed the report. Would that work? I'd like some feedback from real programmers before I proceed. I'm trying to accomplish this with the least amount of effort. Thanks!
Ben
