Hi

I have field in DB Archive, which contain value 0, 1. If 0 then records hide, If 1 then record show.

In my normal property page loading time its working fine, but when I am going to search by advanced search page the page does not filter with 0,1.

I made the search result page like:

SELECT Status, Region, Type, Bedrooms, Price_Range, Title, Features, Short_Description, Property_ID, Imain
FROM DRE_Let
WHERE Region LIKE '%MMColParam1%' AND Type LIKE '%MMColParam2%' AND Price_Range LIKE '%MMColParam3%' AND Bedrooms MMColParam4 AND Postcode LIKE '%MMColParam5%' Archive = 1
ORDER BY Per_week ASC

I just added at the end Archive = 1, is that right? The page is not working with this line, Please anyone help me out with advice.

I will be realy glad to hear from you guys.

Regards

Babu

Hi there,

Problem solved, it was a silly mistake, now its working fine.

Re: Archive = 1 it should be WHERE Archive = 1 AND blah blah blah

Thanks

Babu