PHP Gurus,
I have a database of events which happen on various dates. I've
set up a query to select all the dates within the current month. I've
got a calendar which shows one month at a time, as a table, on which to
display the relevant dates as links.
My problem is that I can't figure out how to compare the results
of the query to the dates on the calendar so that they display on the
right dates.
I thought I should put those date in an array and then on each
date, search that array for a matching date, and if it's found, then
display a link on that date. But my first obstacle was getting the
results of my query into an array.
I first thought I could just use mysql_fetch_array(), but I am
obviously mistaken. According to php.net, that will make an array out of
the columns in the currently selected row. But I want to make an array
out of *all* the rows I have. Each row has only one entry, the date.
I'm looking through all the mysql_* commands that are listed on
the left side of the page, and I don't see any commands that do that.
Surely this kind of action is common enough to merit having it's own
command...?
As I read further, I wonder if my plan is flawed. I thought
mysql_data_seek would search the array based on my criteria, and then
return true or false. But what it says on php.net is very confusing for
me, so I have to admit I'm not sure what it does at all.
I guess what I really am asking is, what is the most efficient
way for me to compare the dates on the calendar with the dates in my
database and display matches as links.
I mean, I could put my mysql_query command in the while loop
that renders the calendar, and search for matching dates that way. But
that means searching the whole database table roughly 30 times each time
the page is accessed, and that can't be right. I'm sure this is better
handled with arrays, but I can't quite figure out the logic and the
commands.
Can anyone help me out with this?
--
Cheers!
Dave G
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
