68 Classifieds Forums - Advance search

68 Classifieds Forums (http://www.68classifieds.com/forums/index.php)

- v3.1 Questions & Support (http://www.68classifieds.com/forums/forumdisplay.php?f=19)

- - Advance search (http://www.68classifieds.com/forums/showthread.php?t=2531)

I dont think it searches all the sub cats under main portugal cat that have the extra field selected

At the beginning of this topic when you echoed out $sSQL and printed your results you see this:

Quote:

SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.display, p.description, p.price, p.dateadded, p.expiration, p.pBold, p.pHighlighted, u.state, u.city, u.country,u.phone FROM class_holidaysproducts AS p INNER JOIN class_holidaysproducts_fields ON p.id = class_holidaysproducts_fields.pID AND ( sValue LIKE '%Golf%') LEFT JOIN class_holidaysusers AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' AND p.section IN (17, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188) AND (p.title LIKE '%golf%' OR p.shortDescription LIKE '%golf%' OR p.description LIKE '%golf%') AND p.price BETWEEN 0 AND 9999999 GROUP BY p.id, p.owner, p.title, p.featured, p.section, p.description, p.dateadded, p.expiration, u.state, u.city, u.country HAVING count(sValue) = 1 ORDER BY featured DESC, p.dateadded DESC

From this you can see what it is searching. The categories it is looking for are:
17, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188

Now I am not sure what you searched for then but you can do this to see what all categories it is searching in.

That search was done on the costa del sol cat,
I just searched this cat, text search golf rental apartment and selected extra field golf and I got no results from the search.

They are 24 listings under the costa del sol cat, 21 of them have the extra field golf selected
1 in Alhaurin El Grande
2 in Elviria
3 in La Cala de Mijas
3 in Nerja
2 in San Pedro
6 in Benalmadena
1 in Competa
1 in Fuengirola
1 in Marbella
1 in Riviera

I think that this search should have shown the 21 properties with the extra field golf selected?

Do you know if you have any other extra fields that you do not have searchable that include the word "Golf"?

I have another extra field called "Holiday Rental Property Features" this has a "near golf" option, I thought that it was safe because it was called "near golf"

do you think if I would change the holiday type "golf" option to "golfing" this would fix the bug

That might do it. Because now I believe it is finding two golf which is making it not find only 1. If that makes sense. :) The bad part is you would need to edit each listing and change the option because of the way the extra fields are stored seperatly in the db.

Iv just edited 2 listings changing the golf to golfing and they dont show in search, Im turning this extra field off cos it just dosnt work

would this matter be fixed in V4, if So I'll wait till then