You are here:  » Display all items in a certain price range.

Support Forum



Display all items in a certain price range.

Submitted by Matt Allan on Tue, 2008-10-28 17:30 in

Hello David,

I've found a few posts that are similar but I couldn't quite follow, hope I'm not asking the same question again.
I would like to create pages that show all products within a certain price range, eg £100-£200 and so on.

I could link to them from the sidebar.
The site I am working on is www.satnavs-direct.co.uk

Regards,

Andy

Submitted by support on Tue, 2008-10-28 17:56

Hi Andy,

First stage for anything like this is the min/max price mods that you will need to add to search.php. I'll email the patch over to you - you won't need the new html/searchform.php to do this, but the changes in search.php and html/navigation.php will be required. If you have heavily modified your search.php and not sure what changes are required feel free to email it to me and i'll patch the changes in for you...

Cheers,
David.

Submitted by Matt Allan on Tue, 2008-10-28 18:33

Thanks David,

I have inegrated the search.php with my own and copied navigation.php over. I have not altered the search form as I am happy with it how it is.

I would like to hard code a link that displays all items within a price brand, can you tell me how to do that?

I have tried a couple of test searches and get the following error;

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/satnavsd/public_html/includes/database.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/satnavsd/public_html/includes/database.php on line 26

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/satnavsd/public_html/includes/database.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/satnavsd/public_html/includes/database.php on line 26

Warning: Cannot modify header information - headers already sent by (output started at /home/satnavsd/public_html/includes/database.php:21) in /home/satnavsd/public_html/html/header.php on line 12

Any idea what I've done wrong??

Submitted by support on Tue, 2008-10-28 18:35

Hi Matt,

Sounds like something not quite right in the modification - can you send me your search.php, i'll check it over and then send it back with the debug version of database.php that will reveal whatever the database problem is...

Cheers,
David.

Submitted by Matt Allan on Wed, 2008-10-29 16:39

Thanks again David