[musiccreatures]

I am writting a Classified Ads module. Currently I am using a Database table for Classified Ads as well as a database table for Classified Ad Categories. I am working on the custom ranking modes, and am running into an issue with the query. I need to be able to return a list of Classified Ad Categories(for navigation) as well as a list of Classified Ads within the Classified Ads Category.

Would it be best to modify the module to use 2 form controllers and 2 ranking scripts? IE: jrClassifiedAds.php form controller and jrClassifiedCategories.php form controller and then write 2 scripts within the ranking directory, jrClassifiedAds.php and jrClassifiedCategories.php?

or would it be best to use the _search_areas function for just the ads and then use a variable like $task to place a switch within the _query function, that tells jamroom whether to build a query for the ads or the categories?

Any advice would be greatly appreciated.

[smith.kyle]

I would just use one form controller and one ranking script. Instead of doing it as a search_area, set up your script to accept a "category" parameter.

Kyle


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...

[Brian]

Check out order "6" to the song mode - it does basically what you are looking to do. The secret is that in a specific order (say 6 for song), there is additional "group by" clause int he SQL query that collapses the results down to one entry per group by column.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation

[musiccreatures]

Thanks for the help guys. bigguy, that is exactly what I was looking for. Thanks again. Hope to have this finished and in testing by this weekend. So far, its pretty robust in features.

[dorou]

Are you planning on making this available for other Jamroom owners (for free or sale)? I would be interested....I was working on defining what I wanted but haven't started coding anything yet.