Re: simple events calendar using mysql
- From: "Shelly" <sheldonlg.news@xxxxxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 13:10:41 -0400
jsd219 wrote:
My appologies, i know how to do the query but i do not know how to
tell the code to display the title and a link to a trip that matches
the date. in other words where in the code below do i say ok, now that
the calendar is displayed, if 10/31/2007 has a trip in the database
You don't! What I mean by that it is not "now that the calendar is
displayed,". You have to put it in AS you are building your display!
In other words, when you do your query, have it ordered by date (ORDER BY
the_date_field). Then build an array with all those rows. Now, as you are
going about building the display of your calendar, check the date against
the next one in the array. If it matches, then do an
echo 'value="' . $whatever_info_you_want_to_appear_here . '"'; (that last
was single-double-single quotes).
and increment your position in the array so that the next time you check the
date it will be the next one in the array. (Of course, stop all this
checking once you have done all the elements in the array so that you are
not going to get an out-of-bounds problem).
Do you understand now?
Shelly
.
- References:
- simple events calendar using mysql
- From: jsd219
- Re: simple events calendar using mysql
- From: Shelly
- Re: simple events calendar using mysql
- From: jsd219
- Re: simple events calendar using mysql
- From: Shelly
- Re: simple events calendar using mysql
- From: jsd219
- simple events calendar using mysql
- Prev by Date: Re: Session or browser problem??
- Next by Date: Re: [PHISHING]: Re: CURL: Result on console and in PHP are different
- Previous by thread: Re: simple events calendar using mysql
- Next by thread: Multiple Domains; 1 Server; 1 PHP Install; Only One Domain Has A Working PHP; WHY??????
- Index(es):
Relevant Pages
|
