Why doesnt this work?
Posted: Wed Sep 08, 2010 1:09 pm
Hi !
I am trying this code:
The 'blocked' row has the following value: "se dk no uk es"
Now, what I want it to do is to NOT include that row IF it finds "no" in the blocked row... The problem is that it dont block it :/ It works if I dont use wildcard characters and the 'blocked' row = 'no' but I want to have multiple values in that row...
Thanks in advance
I am trying this code:
Code: Select all
$query = "SELECT * FROM `table` WHERE name LIKE '%$keyword%' AND blocked != '%no%' ORDER BY hits DESC LIMIT 10 ";Now, what I want it to do is to NOT include that row IF it finds "no" in the blocked row... The problem is that it dont block it :/ It works if I dont use wildcard characters and the 'blocked' row = 'no' but I want to have multiple values in that row...
Thanks in advance