How would one, in an application system, make it so that when the application has been reviewed by a user and the application accepted or denied, the time + datestamp be applied to the application, or even have a table of application IDs which would achieve this? Thanks ct
I apologise for the lack of clarity in my aforementioned post. Here we go again I am building/coding an application system. Currently, a user applies and this information is stored via a database. On a control panel available to staff only, a member of staff reviews it and approves/dissaproves it. I would like it so that the applications are stored, but also, other members of staff can check the application, seeing who approved/dissaproveed it and when it was approved/dissaproved. I hope that clears up any misunderstanding. Thanks.
Think you would just create a log table which would store the information (reviewer, status, date approved, etc). And have it accessible by admin or privileged users.Keyed by the application ID given to the application under review.
Hi, how do I implement this in terms of PHP coding and MySQL: Create an extra column in the SQL table, and what for php: (I get stuck here)