Re: [PHP] Reoccurring task manager

2007-06-15 Thread Daniel Brown
On 6/15/07, Jason Pruim <[EMAIL PROTECTED]> wrote: > [PHP] >L> File: viewall.php > // Include files, connection routines, configuration, blah, > blah, blah > $dow = (date("N") - 1); > > $sql = "SELECT task_name FROM tasks WHERE completed='0'"; > $sql .= " AND (day_of_week BETWEEN '

Re: [PHP] Reoccurring task manager

2007-06-15 Thread Jim Lucas
Jason Pruim wrote: On Jun 13, 2007, at 4:03 PM, Daniel Brown wrote: [PHP] L> File: viewall.php // Include files, connection routines, configuration, blah, blah, blah $dow = (date("N") - 1); $sql = "SELECT task_name FROM tasks WHERE completed='0'"; $sql .= " AND (day_of_week B

Re: [PHP] Reoccurring task manager

2007-06-15 Thread Jason Pruim
On Jun 13, 2007, at 4:03 PM, Daniel Brown wrote: [PHP] L> File: viewall.php // Include files, connection routines, configuration, blah, blah, blah $dow = (date("N") - 1); $sql = "SELECT task_name FROM tasks WHERE completed='0'"; $sql .= " AND (day_of_week BETWEEN '0' AND '".$

Re: [PHP] Reoccurring task manager

2007-06-13 Thread Richard Heyes
Jason Pruim wrote: > Okay, so I have been searching and trying all day for something so simple... All I want is the ability to pick a task that my business has to do such as Emptying the trash... And do this with it: > > Task: Empty Trash > Description: Empty Trash every monday morning > When

Re: [PHP] Reoccurring task manager

2007-06-13 Thread Daniel Brown
[MySQL] L> Table: `tasks` L> Columns: `id` (auto_increment), `task_name`, `completed`, `day_of_week` [PHP] L> File: viewall.php L> File: update.php L> File: cronjob.php [cron] 40 03 * * * /path/to/cronjob.php >> /dev/null 2>&1 NOTE: This was entirely typed directly into

[PHP] Reoccurring task manager

2007-06-13 Thread Jason Pruim
Okay, so I have been searching and trying all day for something so simple... All I want is the ability to pick a task that my business has to do such as Emptying the trash... And do this with it: Task: Empty Trash Description: Empty Trash every monday morning When Garbage is empty click check