Instant Search

[torvista]

too much headache i would say!

Thanks! You are right, there are bigger fish to fry than this!

[DigitalShadow]

Is it possible to show current stock levels for product results?

[DigitalShadow]

Is it possible to show current stock levels for product results?

I've tried my hardest, and I can't figure out how to edit the code to use the 'c' return field to display the stock level for the product. It shouldn't be too hard as it is setup to show the product count for categories.

[DigitalShadow]

Done it.

"SELECT " . TABLE_PRODUCTS_DESCRIPTION . ".products_name, " . TABLE_PRODUCTS . ".products_quantity

		$prodquantity = ($dbProducts->fields['products_quantity']);
		$prodResult = strip_tags($dbProducts->fields['products_name']);
		if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
			$results[] = array(
				//we have 4 seperate variables that will be passed on to instantSearch.js
				//'q' is the result thats been found
				//'c' is the number of item within a category search (we leave this empty for product search, look at the example bellow for category search)
				//'l' is used for creating a link to the product or category
				//'pc' lets us know if the word found is a product or a category
				'q'=>$prodResult,
				'c'=>$prodquantity,
				'l'=>$dbProducts->fields['products_id'],
				'pc'=>"p"
			);
		}else{
			$resultsAddAfter[] = array(
				'q'=>$prodResult,
				'c'=>$prodquantity,
				'l'=>$dbProducts->fields['products_id'],
				'pc'=>"p"

yay

[DigitalShadow]

It would be great to be able to separate the in stock results from those out of stock.... hmmmm

[DigitalShadow]

figure that out too,

modify this

if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
$results[] = array(

[AyoobG]

figure that out too,

modify this

if (strtolower(substr($prodResult,0,strlen($wordSearch))) == strtolower($wordSearch)){
$results[] = array(

Not Bad!