Hi,

Just trying pull out data from db, A simple text box with keywords.

Database Culum name Archive which holds 1 or 0 value.

SELECT Status, Region, Title, Short_Description, Features, Type, Furnished, Bedrooms, Per_week, Property_ID, PostCode, Imain
FROM DRE_Let
WHERE Title LIKE '%MMColParam%' OR Region LIKE '%MMColParam%' OR Type LIKE '%MMColParam%' OR PostCode LIKE '%MMColParam%' AND Archive = 1
ORDER BY Per_week ASC


I am trying to pull out all the Archive value 1 from DB, this way my it is not working. Is there any alternative I can pull out the data???

Please any advice would be really appreciated.

Babu