hii folks i have doubt on mysql
friends i'm trying with mysql like and OR operator but i'm not getting exact output.
FROM registration1 JOIN registration2
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....
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?
keyskills data type is VARCHAR(50), and I'm getting output with out that keyskills LIKE '%$search%'
Might I suggest that in copy and paste the actual PHP code being used to define the query here, in between [php]...[/php] tags, so that we can see exactly what you are doing?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)