Blog Calendar help

Need to link date on calendar to journal entry in database

[Meyer9]

I created a small monthly calendar that displays the days. My question is how do I link dates on the calendar to journal entries in my database?

My fields in the journal table are: ID, MDY, Entry
(MDY stores in the mm/dd/yyyy format)

Here is the code for the calendar:

Correction the code for the calendar WAS here. Hey all you code jockeys, please review this discussion [webmasterworld.com] about posting code.

[edited by: DaveAtIFG at 1:40 am (utc) on Dec. 8, 2003]

[txbakers]

Hi. the problem is fairly easy. You need to open a new page which will read from the database based on the date parameter chosen by the user.

So, for each clickable date, the code looks like this:

<a href="detailpage.asp?date=<%=thedate%>">6/7/2006</a>

On your detailpage, you have a query which retrieves the information based on the date.

If you want to see a working example, send me a sticky mail and I'll send you a URL.