hii folks i have doubt on mysql

This site is best viewed in a modern browser with JavaScript enabled.

ramyasri

friends i'm trying with mysql like and OR operator but i'm not getting exact output.

SELECT registration1.,registration2.
FROM registration1 JOIN registration2
ON registration2.emailid=registration1.emailid
WHERE(keyskills LIKE '%$search%') OR (keyskills='$search1')

this is my code. LIKE operator is working properly but keyskills='$search1' this is not working while using keyskills LIKE '%$search%' this. please let me know what mistake i did...
please friends it's very urgent help me....

NogDog

What type of field is "keyskills"?

What is the actual value of $search1 when you get to that point? (Not what you think it should be, but determine via debugging what it definitely is.)

If it's a text value, (which you are indicating by having quoted it), have you properly escaped any special characters with the applicable function for whichever database extension you are using?

ramyasri

keyskills data type is VARCHAR(50), and I'm getting output with out that keyskills LIKE '%$search%'

NogDog

Might I suggest that in copy and paste the actual PHP code being used to define the query here, in between [noparse]

...

[/noparse] tags, so that we can see exactly what you are doing?