SELECT mis mask

gjessing · 02-17-2009, 07:16 AM

what is wrong with this line.

because it dont care about the aktiveret (if it is 1 or 0 it takes it with anyway)

Quote:

$sqlquery = "SELECT * FROM profiler WHERE aktiveret = '1' AND navn LIKE '%".$searchterm."%' OR html LIKE '%".$searchterm."%' ";
$query = mysql_query($sqlquery) or die(mysql_error());
if(mysql_num_rows($query) == 0){

abduraooft · 02-17-2009, 08:24 AM

If it's an integer filed, remove the quotes around the value

Code:

....WHERE aktiveret = 1 ....

gjessing · 02-17-2009, 09:00 AM

hi - no it still take the aktiveret with if the value of it is 0

abduraooft · 02-17-2009, 09:03 AM

Umm..

Code:

$sqlquery = "SELECT * FROM profiler WHERE 
aktiveret = 1 AND navn LIKE '%".$searchterm."%' OR html LIKE '%".$searchterm."%' ";

is equivalent to

Code:

$sqlquery = "SELECT * FROM profiler WHERE 
(aktiveret = 1 AND navn LIKE '%".$searchterm."%') OR html LIKE '%".$searchterm."%' ";

So the query will return all case that matches

Code:

html LIKE '%".$searchterm."%' ";

I think you need

Code:

$sqlquery = "SELECT * FROM profiler WHERE aktiveret = 1 AND 
(navn LIKE '%".$searchterm."%' OR html LIKE '%".$searchterm."%') ";

gjessing · 02-17-2009, 09:08 AM

YES YES

you are the greatest.

Thanks a lot - now it works like cream