16
I have been using XOOPS for about a month and have been quite impressed with the system and how configurable it is. I am looking to rebuild an old project of mine. It is a karaoke site. The old site was built usig Front Page and Access 2000. I want to build the new site with Xoops, PHP, and MySQL. I want to have forums, news, reviews, etc.
What I want is a database of locations to do karaoke. The table will have data on what nights a week that establishment has a show, who is the jockey, what sort of drinks they have (beer/wine or liquor), whether they have food, pool tables, darts, basic info about the establishment, a map link and link to get driving directions.
On the old site, a visitor could check a few checkboxes on a form and submit a query. For example, list all bars that serve liquor and have karaoke on Tuesday nights in Tampa. Up would come a results page, with each listing being a link to a dynamic sumary page of that bar.
As I said, I was able to do this in Access with a Front Page wizard to build the forms and queries. Is there a XOOPS module, either current or in development, that has that sort of functionality? Or am I looking at building queries in PHP and banging on this myself?
Any help appreciated.
