Need help

[scialom]

Hello,

I want to create a weekly view of my employees to see what they do every day.

It should look like:

 
                      20/2        21/2      22/2      23/2    24/2       25/2      26/2
Employee 1    Job1    Job1      Job2      Job2     Job3      Holiday
                      Job2      Job3      Job3     

and so on for each employee.

I get from the database for each on this info:
Job1: Start date = 20/2
End date = 21/2

Job2: Start date = 21/2
End date = 23/2

Job3: Start date = 22/2
End date = 23/2

Any ideas what is the best way to do it?

Thanks,
Assaf

[RyanJones]

scialom wrote:

Any ideas what is the best way to do it?

Well, you'll probably need to use a batabase unless you intend to use a flat-file system 🙂

So I suggest you start reading up on MySQL 🙂

www.php.net/mysql

Cheers,

Ryan Jones

[scialom]

I am using mysql to get the info

[max_php]

RyanJones wrote:

Well, you'll probably need to use a batabase

Is that a new technology? 🙂

[Houdini]

It looks like you would need to have about four data columns like empid, jobid date_start, and date_end the empid and jobid would be smallint or int data types and the date_start and date_end would be date data types in the form of yyyy-mm-dd for MySQL. To convert back to your desired date format you would use PHP date or time functions to output the data the way you wanted.

[scialom]

Maybe I didn't explain my problem well enough. I know how to connect to the db and get the info. This is not the problem.

My problem is that I try to find an elegant way to develop it. At the moment all I can think of is running each day and select for each employee his relevant jobs. This will make it extremely slow (7 days * 10 employees = 70 queries to the db).

Any ideas?
Thanks,
Assaf