Calendar Mysql Records and arrays

[WebRuss]

Greetings all - been a while

Okay so, I am working on a simple (heh) calendar program that displays a month view of a calendar with links within each day that link to the events.

I'm having trouble figuring out how to get the list of events for each day. You see If a month has 30 days I don't want to query the database 30 times. I'd rather query it once and then work with the recordset inside the for loop that builds each day.

However, I'm having trouble figuring out how to get around inside a recordset returned from a MySQL database on Linux. I know I can use mysql_fetch_array() or mysql_fetch_row() but are not these methods forward only?

I guess I would like to be able to move forward and backward in the returned resultset.

I'm wondering if I should read the recordset into a two dimensional array with all the records and then use it that way..

Anyone have any thoughts?

Regards
WebRuss

I guess I need a solution

[matt_4013]

If I'm reading correctly, what you're doing is this: Getting all of the events/records for the month, then using a for loop to create each day, and you want to get the corresponding records from your result set, to use inside that for loop, right?

Why don't you go the other way. Get all of your events/records for the month, ordered by datetime ascending. Then, loop through your record set, and when the day changes in your record set, create a new day on the calendar? Apart from that, you could try and hack your way through the result set using mysql_data_seek

Hope that helps,
Matt