Search by Date and Place

[Daria]

Hi, guys! Posting in General, since I don't know if it's PHP, MySQL or anything else...

Sorry, I know I might find the info if I spend some time searching, but I'm totally drained!!!!!

On one of the websites I have event happening on different dates in different locations. Sometimes there maybe a dozen of different locations on the same date, sometimes there maybe a dozen of dates for the same location.

I want to build a database-driven site, where people can perform search by date and place (and, ideally, have a feature of entering zipcode and finding and events nearest to you).

PLEASE, PLEASE, PLEASE, if something like that already exists, (not the site, of course, but a code for the search funct. of that type) free or fo reasonable amt.of $$ (no custom work offers please, I'm broke - ha-ha) - PLEASE, PLEASE, PLEASE, feel free to advise

Right now I have to enter all the info manually and it get's updated fifteen times a day, the page on the website is 3 miles long (w3c will eat me alive), my client wants it all in tables, I'm going bananas! A good solution for a search by: would save me from going postal. Thanks.

[PeOfEo]

Well if you want this to be exactly how you like it you will have to do it yorself. You dont have to use PHP or MYSQL, you can use any server side technology. For instance you can also use ASP ASP.NET JSP CGI Cold Fusion SHTML etc. Also updating would be a snap if you learned a server side langauge because the server outputs the html so you can just store the data in a data base then have the server make the .html pages for you esentially. You are going to need to figure out what technologies your server supports and then you are going to need to go to books a million and do a little bit of back cover reading and page flipping and get a nice thick tome of knowledge on whatever technologie you want to use. Thats my suggestion anyway.

[Daria]

Our server supports everything.

You are right, one should be better off doing some legwork. Yet I am extremely pressed for time, it's one of those cases when I need a solution FAST, at least for time being until I figure out a better way to do it (i.e. hitting books and such).