Instant Search

[wirefram]

What is missing is the categories_status in the sql query, i tried to add it but i am still getting the mod to display disabled categories...

Can someone let me know what is wrong in my query?

//similar to product search but now we search witin categories
$sqlCategories = "SELECT categories_name, categories_id, categories_status
FROM " . TABLE_CATEGORIES_DESCRIPTION . " , ".TABLE_CATEGORIES."
WHERE " . TABLE_CATEGORIES . ".categories_status <> 0
AND (categories_name LIKE :wordSearchPlus:)
OR (LEFT(categories_name,LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:)
ORDER BY
field(LEFT(categories_name,LENGTH(:wordSearch:)), :wordSearch:) DESC
LIMIT 4";

Thanks

L.

[bigstore]

I'm having CSS issues with my Instant Search also. I moved the search bar up above the navigation, just below the top of the page.
Every time I enter text into the search field the popup results container pushes the test that I'm entering down below said container.


Thanks

[familynow]

I just added this mod and for some reason it messed up the java slider. There were no file overwritten during the upload. Can the two not co-exist?

familynowDOTca

[familynow]

Just FYI since I'm working on the live site I deleted jquery.js and all instant_search js files.

[familynow]

Fixed it. Replaced instandSearch.js with the code on post #41 and the clashing btwn the slider and search stopped.

My next question if I may is, how would I apply the exact same css as my main menu? I tried a bit and didn't get anywhere.

Also, the pop-up seems slow. If it were me, I'd likely hit the search button or enter way before the js pop-ups the list. Is that adjustable?

[familynow]

I got opacity but I can't get the background-colour property to work nor can I get the rounded corners

.resultsContainer a {
display : block;
padding : 0.1em 0.4em;
text-decoration : none;
overflow:hidden;
height:18px;
opacity:0.95; filter:alpha(opacity=95);

.resultsContainer ul {
margin : 0;
padding : 0;
background-color: #0D474E;
border-radius:3px 3px 3px 3px;
-moz-border-radius:3px 3px 3px 3px;
-webkit-border-radius:3px 3px 3px 3px;
list-style-type : none;

[MikeyG]

AyoobG

Sorry not got back sooner.

Currently my site on a product info page loads as follows:

<script type='text/javascript' src='/includes/modules/pages/product_info/jscript_1_mootools_complete.js'></script>
<script type='text/javascript' src='/includes/modules/pages/product_info/jscript_2_imageViewer.js'></script>
<script type='text/javascript' src='/includes/modules/pages/product_info/jscript_ajax_image_swapper.js'></script>

<script type='text/javascript' src='/includes/modules/pages/product_info/jscript_textarea_counter.js'></script>
<script language="javascript" type="text/javascript"><!--
function popupWindow(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screen X=150,screenY=150,top=150,left=150')
}
function popupWindowPrice(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=600,height=400,scree nX=150,screenY=150,top=150,left=150')
}
//--></script> <script type="text/javascript"><!--
var FualSlimboxOptions = new Class({
initialize: function(){
this.transitionType = new Fx.Transition(Fx.Transitions.Sine, 5);
this.resizeFps = 60;
this.resizeDuration = 500;
this.resizeTransition = this.transitionType.easeInOut;
this.initialWidth = 100;
this.initialHeight = 100;
this.animateCaption = true;
this.defaultIframeWidth = 500;
this.defaultIframeHeight = 300;
this.elHide = ".zenLightboxHideMe";
this.displayVar = "Var";
this.pageOf = "Page #1 of #2";
}
});
//--></script>
<script type="text/javascript" src="includes/templates/funkymoose/jscript/slimbox/slimbox_ex.compressed.js"></script>
<script type="text/javascript"><!--
var fualNervous = 1 //--></script>
<script type="text/javascript" src="includes/templates/funkymoose/jscript/slimbox/fual_slimbox.compressed.js"></script>
<script type='text/javascript' src='/includes/templates/funkymoose/jscript/tpp.js'></script>


This is all the .js files in the header.

It does not appear to call a jquery.js file but I am guessing one of the others like mootools that causes the clash

[AyoobG]

What is missing is the categories_status in the sql query, i tried to add it but i am still getting the mod to display disabled categories...

Can someone let me know what is wrong in my query?

//similar to product search but now we search witin categories
$sqlCategories = "SELECT categories_name, categories_id, categories_status
FROM " . TABLE_CATEGORIES_DESCRIPTION . " , ".TABLE_CATEGORIES."
WHERE " . TABLE_CATEGORIES . ".categories_status <> 0
AND (categories_name LIKE :wordSearchPlus:)
OR (LEFT(categories_name,LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:)
ORDER BY
field(LEFT(categories_name,LENGTH(:wordSearch:)), :wordSearch:) DESC
LIMIT 4";

Thanks

L.

hi sorry for late reply,

replace it with this code:

	$sqlCategories = "SELECT cd.categories_name, cd.categories_id, c.categories_status
			FROM " . TABLE_CATEGORIES_DESCRIPTION . " cd INNER JOIN " . TABLE_CATEGORIES . " c ON cd.categories_id = c.categories_id
			WHERE (c.categories_status = 1) AND ((cd.categories_name  LIKE :wordSearchPlus:) 
				OR (LEFT(cd.categories_name,LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:))
			ORDER BY  
				field(LEFT(cd.categories_name,LENGTH(:wordSearch:)), :wordSearch:) DESC
			LIMIT 4";

[Shapirosupply]

I'm trying to install this add on at www.shapirosupply.com and am having problems. All the files are in the right places and my search box is not any different than before. I'm thinking that it could have something to do with the photobucket slideshow but it is still working fine. Any advice? Thanks.

[AyoobG]

You sure you uploaded file, i can't see instant search in source code.

I'm trying to install this add on at www.shapirosupply.com and am having problems. All the files are in the right places and my search box is not any different than before. I'm thinking that it could have something to do with the photobucket slideshow but it is still working fine. Any advice? Thanks.