Hi David,
How can I get the search results (and related sites) to show the description for each result (in my case the merchant URL)? Since in my implementation the description is only contained in the "lowest price" "merchant" it seems to be flakey.... If I search 'products' in a specific 'merchant' (one of the "Support" ones that contain the descriptions) the descriptions show up but when I do a search by name only those that have only support links and none from any other merchants show up.
Examples - general search results:
http://rewardsdb.com/search.php?q=1800
Within a "Support" merchant:
http://rewardsdb.com/merchant/Support-RewardsDB/
as you can also see, the images also are not showing up.
Any ideas?
Thanks,
Andrew
Hi Andrew,
I understand what you mean. Because the search results query uses a GROUP BY clause, there is no way to force MySQL to select the non-grouped fields from a particular record. I'll look into this for you but isn't an immediate quick fix...
Cheers,
David.