Dynamic calendar Looping

cmdr_bond

I'm wondering if there is an easy way to do this:

I am trying to make an event calendar for my website where I list all the events that are on a given date for each day of a month. I think it's too complicated to make a dynamic month generation so I decided to make a table manually for each month of the year. But what I want is to output from a table of events the events on a given date. However, as I have it now, I would be making 31 separate mysql queries and it seems like an inefficient way to go about it. Is there a way to loop it to do it automatically?

trex005

Originally posted by cmdr_bond
I think it's too complicated to make a dynamic month generation

sounds like you may need to do a little rethinking from the begining... yes, it would be much more complicated to build sewage/spetic systems but we really need to move past the dumping of bodily waste into the city streets!

liquorvicar

total agreement with trex005, making your months static is madness.

in reply to your other query. rather than 31 queries, why not do just one query per month and put the results into an array:

array( '1st of the month'=>array(list of events for that day),
'2nd of the month'=>array(list of events for that day), etc)

cmdr_bond

So how would I go about making a multi-dimensional array like this?

(note: I save my event dates as 04/12/2005 7:00PM

 
$sql = "select * from events where eventdate LIKE '04/%' ORDER BY eventdate"; 
$sql_result = mysql_query($sql) or die ("Could not select data"); 
$date = explode("/", $sql_result[eventdate]);
$datearray = ('1'=>

I'm not really sure how you would separate each date into a separate array. Do you have a solution to this?