>So you're searching in the title and description columns of a products >table? > >Is the GROUP BY needed? I'm not sure it is at this stage.
I do believe I need to still group it all. Results can come from multiple colors and sizes of a single model code. That would give way too many. By grouping them, I'm filtering down to one. here's the page in action as it stands right now. Search for "test". Don't pay attention to the rest, I'm waiting on images from the client. :) http://209.200.88.199/ Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
