Jump to content


Photo

querying the database


  • Please log in to reply
2 replies to this topic

#1 krausehaus2

krausehaus2
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 05 October 2006 - 02:39 AM

I am trying to create a calendar that shows the specific special event on a certain date.  I have the calendar already created but when I query the database to put in the events, I can only put the last event in the calendar.  When I am querying the database I am using a while statement to retrieve the events.  Is there any other way I can work around this?

#2 thekl0wn

thekl0wn
  • New Members
  • Pip
  • Newbie
  • 5 posts
  • LocationPoCo, IN

Posted 06 October 2006 - 08:55 PM

I'm not sure I follow... Could you give the code?


#3 krausehaus2

krausehaus2
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 29 November 2006 - 06:49 PM

I found out what the problem was.  When you query the database for the events, it would only show the very last one on the calendar.  So what I did was loop it to where it would run a query for every day of the month.  That way it would find everything in the database per day.  Someone else had answered this question a while ago and I had wrote a reply thanking him and thought this had been closed out.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users