Now that I've answered your question, let me throw in an opinion. If you're building a generic classified system, you might be better off with category, description and maybe a couple fields for contact information. That seems to have worked for craigslist.
Patrick On 11/24/06, Doug Brown <[EMAIL PROTECTED]> wrote: > I am in the process of re-designing a classifieds system and was just > wondering a few things. Currently there is just one standard for to fill out > for the ads. I am thinking of designing it to where it is more useful. I > would like to make the form as dynamic as possible by having different inputs > for different categories of items. The thing is, that I would imagine I would > need to have a databse table for each category. Am I correct in this > assumption? Building the forms would be the easy part, but having say 50 > different tables of info for all categories would be a nightmare. Any > suggestion would be appreciated. > > IE: > > [Real Estate Form] > > Price > Bedrooms > Bathrooms > Garage > Sq. Ft. > Acreage > Covenants > etc. etc. > > [Auto Form] > > Make > Model > Year > Miles > etc. etc. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
