Instant Search

[ShopVille]

Nice mod!

installed on shop running 1.5.0 today!

just one question, i have a bilingual shop but instant search results appear in both languages anyway to avoid it?

Thanks

[jeffmic]

Hey gang,

Can I get a bit of help so the results also adds the model number to the right of the product name?

thanks in advance

[DrByte]

From very briefly looking at the searches.php, I'm guessing the following two tiny updates would do that:
line 49

    $sqlProduct = "SELECT " . TABLE_PRODUCTS_DESCRIPTION . ".products_name, " . TABLE_PRODUCTS_DESCRIPTION . ".products_id, " . TABLE_PRODUCTS . ".products_status, " . TABLE_PRODUCTS . ".products_model

and line 70

        $prodResult = strip_tags($dbProducts->fields['products_name'] . ' [' . $dbProducts->fields['products_model'] . ']');

[jeffmic]

thanks for jumping in Dr Byte, but this breaks the code result. The plugin no longer functions.

[DrByte]

Are you sure you didn't miss a . or , or ' or " or ) or ] ? I can't see any syntax errors.
(And sometimes copy+paste might introduce weird characters etc)

Anything in debug logs? http://www.zen-cart.com/content.php?124-blank-page

[jeffmic]

This time I only inserted the part you had above in Red and it did indeed work correctly :-) Previously, I just copied your entire code over the older code and nada. Hmm.... Thanks again. Now I can play with the look and feel of it.

[jeffmic]

OK, I got it almost showing like I want. Just 2 more small things.

1 - How can I avoid it from displaying only all lower case?

2 - I chose to add the Products_description field instead of code too (which I now got working fine), but on the standard Advanced Search result page, I have line breaks (or returns- not sure) for this field and it displays a space just fine instead of a line break. But in the Instant Search it's removed and doesn't have that space anymore. The end of the original line 1 and the start of line 2 are butted up against each other. Can the space appear again? OR can a standard line break work like normal for the remaining text similar to the product INFO page?

Here's how Advanced search displays this song:
http://store2.musicalcreations.com/i...148008&x=0&y=0

Then in my search, type in: I Knew You Were Trouble
and you will see the T in Swift and the K in Key are connected with no space.

[jeffmic]

1 - I found a way to modify the original text in the products_description field to fix my problem above and have it look proper throughout the search results.
Changed: <br />
to: 'space'<br />•'space'

Previous look: in the style of: BEYONCEKey: B - Time: 1:30
New look: in the style of: BEYONCE • Key: B - Time: 1:30

I didn't need to insert the other code you sent for this. I couldn't get it to work well, so I did a mySQL replace for this new modification of the field instead.

2 - The code you gave me for removing the lowercase only display works PERFECT!!

thanks so much once again.

I'm almost ready to go LIVE with the new site now...

[avotecnica]

Hello, sorry for my bad english..but i'm italian..
I have found a problem in the mod...
I have many products that the name is "pistone.....and other word...". if you write "piston" in search you can see only 2 results...why?
My site is www.avotecnica.com thanks...