Shaun wrote:
Hi,
I am creating an online timesheet application. Most parts are done, however
I have a problem displaying a list of unapproved timesheets.
Here is my timesheet table:
mysql> DESCRIBE Timesheets;
+-------------------+-------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-------------------+-------------+------+-----+------------+----------------+
| Timesheet_ID | int(11) | | PRI | NULL | auto_increment
|
| Type | varchar(40) | YES | | NULL |
|
| Project_ID | int(11) | YES | | NULL |
|
| User_ID | int(11) | | | 0 |
|
| Hours | float | | | 0 |
|
| Date | date | | | 0000-00-00 |
|
| Status | varchar(40) | YES | | Open |
|
+-------------------+-------------+------+-----+------------+----------------+
When a timesheet is submitted for approval the manager logs in and approves
/ rejects the timesheets. How can I display a list of unapproved timesheets
grouped by week and user?
Write a SQL statement?
http://dev.mysql.com/doc/mysql/en/index.html
http://lists.mysql.com/
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
