search between two values in mysql with array

[iron999mike]

I have an array price_below[] that contains a number, say 10.00. I would like to search my database for numbers lower than that number.
How do I use array variables in my query?

elseif ($cat == 'y' && $price_low == "NULL"
			&& $price_high == "NULL" && $price_below != "NULL"
			&& $price_order == "lowtohigh") {	
	$sql = "select * from wishlist, Description, Category, 
	location WHERE wishlist.desc_id = Description.desc_id && 
	Description.cat_id = Category.cat_id && 
	Description.loc_id = location.loc_id
	&& 'price' <= '$price_below[]' 
	order by 'category', 'price'";
	}	

[OhLordy]

You can't access an array element with $arrayname[] this syntax is used to place another element on the end of the array. I'm not exactly sure what you are trying to use but here are a couple of things I think you may be trying to do.
to access the last element of an array : $arrayname[count($arrayname)-1];
number of elements in the array: count($arrayname);

HTH
Rob