Catalog - access Data from two data table
I am trying to create a property listing using catalog ext module. I have two type of catalog first for residential and second for commercial. Now i want show monthly special property from both residential and commercial. How i manage this requirement of my project?
Re: Catalog - accss Data from two data table
I believe the easiest solution would be to create mysql view using union to include properties from both tables and then use listing module to show the results.
Re: Catalog - accss Data from two data table
Re: Catalog - access Data from two data table
I'd rather have created a unique catalog, with a property type field to display only one type (residential or commercial) on the "standard" pages, and keep the opportunity to display both wherever I want.
Re: Catalog - access Data from two data table
You have done this correctly -- Create only 1 catalog but have a drop-down that chooses RESIDENTIAL or COMMERCIAL. Then you have a single catalog to run queries against. I prefer to have single catalogs than multiples.