Contributions

This is a full package containing files fixed for compatibility with MySQL5.

The previous download of this contribution had a bug. It meant the attribute drop downs were populated with the option values of other options (e.g. you may end up with Colour => 14" or Size => Blue etc).

This fixes the bug. Full package.

Advanced search attributes fullpackage with all updates.Only upload and change with old files

( advanced_search.php and advanced_search_result.php)

Enjoy...

my mistake again, this should be right one

dont download the previous file, this is the right one, HOPEFULLY

I had problems when I use with Mysql 5.0.

Hopefully this update will help people to use this contribution with mysql 5.

Regards

When you click the "back" button after performing a search I found that the
values that had been selected in the attributes drop down lists were reset to
the default empty values.

I would prefer it to remember the selection I had

chosen so I could refine it rather than reselect them all again.

I found that products with no attributes were never returned in the search results, even when no attribute values had been selected on the search page.

The attached file explains the fairly simple fix for this.

Hello,
I'm surprise everybody seems happy with this.
For me there's a significant bug (option search criteria are totally ineffective) .

In advanced_search_result.php,
I think the occurences of

$HTTP_GET_VARS[$attributes["products_options_id"]]

AND

$HTTP_GET_VARS[$attributes2["products_options_id"]]

MUST BE REPLACE RESPECTIVELY BY :

$HTTP_GET_VARS[$attributes["products_options_name"]]

AND
$HTTP_GET_VARS[$attributes2["products_options_name"]]


Which sound logical, as the search form says :

echo '<select name="'.$attributes["products_options_name"].'">';

Here's the correct file to me

This is a small modification to Adam's excelent work to allow attribute search drop-down_menu to display only the given options in a given language.

Thanks for this great contribution Adam!!

Same as previous but uses the Options_id instead of tha name wich had problems when you use extended characters like &auml; ...

Before (had problems in URL):

?Gr&ouml;&szlig;e=12&Farbe=23

Now search string looks like :

?1=12&2=23

Wich should be fine because a Option_ID should be unique if the language is set. ( wich is set by standart definition or user selection )

This applies to all who are using special characters wich are not supposed to be used in URLs.

Try it on http://www.kronederschoepfung.de ( as quicksearch Boxes for Size and Bra-Sizes )

This is not really an update but more like a change in the sql statement.

Some version of MySQL didnt like how I told it to do a regular JOIN so I removed the JOIN and put it in the from clause... blah blah blah....

The main thing, is it should work with those versions of OSCommerce now that were getting sql errors because of the join.

Just download the file and replace your existing advanced_search.php and advanced_search_results.php files and give it a try.
Unfortunately, I cant do much more testing because I dont know which version of MySQL doesnt like my join but it works fine on my test server.

same contribution as before but now with screen shots

same contribution as before but now with screen shots

This contribution will replace your existing advanced_search.php and advanced_search_results.php pages. It will give you the ability to search products using their attributes. After replacing these two files you will be able to select their attributes from a drop down list box then after submitting your query the results will be limited to your selection.