Results link - min value in link

Hi Rob,

Try the numeric search ranges are picky - they don't understand commas. Try removing the commas from the link and let me know if that fixes it.

<p><a href="results.php?price_min=1000000">Property over &pound;1,000,000</a></p>
<p><a href="results.php?price_min=2000000">Property over &pound;2,000,000</a></p>

Hi Dave,

Thanks for the reply.

Without the commas, it does and doesn't work...

The prices set within the records DO have commas (i.e. displaying as 2,000,000). So when searching:

<p><a href="results.php?price_min=1000000">Property over &pound;1,000,000</a></p>

...because we're not using commas in the price_min in the link, it displays no results, because the results records DO have commas.

The commas work fine in a select search engine, for example:

<select name="price_min">
<option value="1,000,000">1,000,000</option>
</select>

We want to keep the commas in displayed records as otherwise we're loosing the neatness and style.

If the direct link won't work with commas, I guess I would need to build the direct link in as a form - a hidden <select> field (to take the price_min with commas) with a submit button which is just the link text - so there probably is a way around it, but not as easy or simple as a quick link...

Cheers
Rob

Hi Rob,

There shouldn't be a difference between a text link and a form. So if you double check that and you're getting different results let me know.

Typically what you need to do is have only numeric values in the database and search values. It's a limitation of MySQL that in order to do numeric comparisons it needs no commas. You can prevent the entry of commas by using the field editor and making only "1234567890." allowed characters for the price field.

You can display the price formatted with commas (even if they're not in the database) by using the number_format() function. See this post for more details: http://www.interactivetools.com/iforum/P62471#62471

Hope that helps!

Ah ha, have figured it...

It works when there is just one comma, for example:

<p><a href="results.php?price_min=900,000">Property over &pound;900,000</a></p>

but not when there is more than one, for example:
<p><a href="results.php?price_min=2,000,000">Property over &pound;2,000,000</a></p>

So I think i'll resort to price being number only (no commas) and then using number_format() - more ability to restrict field entry in CMS too by just allow numbers.

Cheers for your help - strange how 1 comma works!

Rob