Re: List of Dates Grouped by Week
| From: | John Nichel | Date: | Tue, 26 Oct 2004 13:57:03 +0000 |
| Subject: | Re: List of Dates Grouped by Week | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200356@lists.php.net to get a copy of this message | ||
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; +-------------------+-------------+------+-----+------------+----------------+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@kegworks.com| 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?