search engine

Thank you for your help

bregent,illbehere

Just so you know, it would be a good idea to give your MMColParam variables a meaningful name rather than the default Dreamweaver name, it will help you keep track of which variables you're accessing in you queries. Bregent is correct, you wanted to search the same variable by two different fields originally, so an OR would give you that result. If you wanted to match values exactly you would use:

SELECT *

FROM WebName

WHERE WebName = meaningfulVariableName AND WebLink = anotherMeaningfulVariableName

ORDER BY WebName DESC

Your current solution will give you results that include characters before and after your query string, so if variable1 = "website" it would also return "mywebsite", "websiteforyou", etc.

I hope this helps, the only reason I am blathering like this is that I have much less hair from trying to figure all this stuff out and I thought I'd save you some of yours :-).

Tom

This is Solution

SELECT *

FROM WebName

WHERE (WebName LIKE %MMColParam1%  OR WebLink LIKE %MMColParam2% ) and UserID = MMColParam

ORDER BY WebName DESC

SELECT *

FROM WebSite

WHERE Name = MMColParam1 OR

WebLink = MMColParam1

ORDER BY NameID DESC