Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 Apr 2011, 00:51
midirtrider's Avatar
midirtrider midirtrider is offline
 
Join Date: May 2006
calendar events searchable?

Im looking for help or even bump in the right direction on a project I am working on..

I need my calendar to be searchable by distance..

this is my goal with it..

So lets say there is an event on 5-21-11 that is in tany given area code

I need to be able to search within X amount of miles of my area code.. .. and it will search the calendar for all the events within that distance..

So not only do I need a search system that works by distance..
but also a feild in the calendar that you imput the area code that the event is taking place in.

does that make sense?

any help would be AWSOME.
__________________
www.MIdirtriders.com
Michigan Dirt riders forum
come be a part of the local dirt
Reply With Quote
  #2  
Old 27 Apr 2011, 02:47
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Do you really mean area code? I've heard of it being done with zip codes. You can find a database of zipcode coordinates (centroids) and in theory it's not too hard to calculate the distance to each one. I'm not sure if it would work as well with area codes since the areas are much larger. I also googled and didn't find anything like an area code location database, but of course that doesn't mean it doesn't exist.
Reply With Quote
  #3  
Old 27 Apr 2011, 14:15
midirtrider's Avatar
midirtrider midirtrider is offline
 
Join Date: May 2006
yea sorry about that Kh99... I was meaning zip code..


I was working on this lastnight for awhile..
I actually think I need to figure something out instead of doing it with calendar events..

Im thinking if I can just save the events (with a zip code tag and date somehow) .. then I would just need to work in a search system to search the database of events by zip code (and date)

any ideas on that?
__________________
www.MIdirtriders.com
Michigan Dirt riders forum
come be a part of the local dirt
Reply With Quote
  #4  
Old 27 Apr 2011, 17:39
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Yeah, it seems to me that figuring out how to have an interface for managing the events is more difficult than the search. In fact I found this page: http://blogs.lessthandot.com/index.p...e-longitude-pr that pretty much says how to do the search.

I'm not familiar at all with the calendar stuff but maybe I'll look at it later.
Reply With Quote
  #5  
Old 27 Apr 2011, 20:29
midirtrider's Avatar
midirtrider midirtrider is offline
 
Join Date: May 2006
thanks.. Ive been searching around pretty heavily trying to find some good solid imput..
have a few leads as well.

Im not the strongest coder though

but I do like the link you provided.. will have to give it a good read in a min here..
__________________
www.MIdirtriders.com
Michigan Dirt riders forum
come be a part of the local dirt
Reply With Quote
  #6  
Old 27 Apr 2011, 23:35
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I noticed looking at that link again that it's specifically "SQL Server" , so I don't know how much of it will work with MySQL.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:07.

Layout Options | Width: Wide Color: