Calendar application

[scialom]

Hello all,

I develop a calendar application for my company. I want to create a page that will display all the jobs per day for the current month.

My problem is that I don't want to create 30 sql queries for each day. i.e:
select from jobs where job_date='2005-07-01'
select from jobs where job_date='2005-07-02'
And so on...

Any ideas for a better solution?

Thanks,
Assaf

[planetsim]

Well yes its possible im not going to code it for you but ill give a little of the logic to what is required. Basically you can call all the jobs now id firstly make sure your only getting the ones that are actually in the month we dont want to be getting too many results. Then from there you should create a multidimensional array and have the main index as the date. Then check if the array index (the date) already exists if so add that record to the Array with the same date.

Ok I lie here is a little example using the loop it doesnt follow exactly to what I said, but nonetheless it should work relatively well. As long as you modify it to your needs.

$array = array(); // we should really say that its an Array mainly for future reference also a good habit to get into.
while ($row = mysql_fetch_assoc($query))
    $array[$row['date']][] = $row;