Now it seems I can't any longer.
I have a table where I store the jobs
Code: Select all
====
jobs
====
job_id
customer_id
address_id
job_dateCode: Select all
=============
jobs_employee
=============
assign_id
job_id
employee_idEach employee can log in and check their own schedule and if they're assigned to a location with somebody else they have that information as well. Also, normally an employee would have 4-6 jobs for one day. job_date is a datetime in a 0000-00-00 00:00:00 format with the specific appointment date and time.
I need to join select job_id, customer_id, address_id and job_date where employee_id = $userId and also where job_date is between $jobLowDate and $jobHighDate and order it by job_date.
Thanks for your help.