Thanks Andy,
search.cgi?query=*;sb=price;so=asc
search.cgi?query=*;sb=price;so=desc
Yes, that is what I wanted to know with regards to sorting but there are a couple of issues -
First, in the earlier thread it works fine the way I want but I have to enter either catname or query=something. It doesn't work if the query=blank or query=* itself and I think that is because the search.pm requires some input. Withe the earlier codes, it would be nice if the query is blank then it will return all listings which I can sort, but for the time being setting that aside the other issue is, below.
The sorting itself does not seem work well because of commas in the price values - hence, I thought we might need a global or something so it sorts the values ignoring the commas - in the future I plan to add a javascript in the form so users submit commas in price values, it will reformat before submitting the price value to the database.
For now, is it possible to run a sql query to remove commas from price values - and if so how?
Thanks!
search.cgi?query=*;sb=price;so=asc
search.cgi?query=*;sb=price;so=desc
Yes, that is what I wanted to know with regards to sorting but there are a couple of issues -
First, in the earlier thread it works fine the way I want but I have to enter either catname or query=something. It doesn't work if the query=blank or query=* itself and I think that is because the search.pm requires some input. Withe the earlier codes, it would be nice if the query is blank then it will return all listings which I can sort, but for the time being setting that aside the other issue is, below.
The sorting itself does not seem work well because of commas in the price values - hence, I thought we might need a global or something so it sorts the values ignoring the commas - in the future I plan to add a javascript in the form so users submit commas in price values, it will reformat before submitting the price value to the database.
For now, is it possible to run a sql query to remove commas from price values - and if so how?
Thanks!