0

can someone explain me wy the folowing query dosn''t work

because i want to select only where the values are 1 , 2 , 3 , 4 and so ond and count these rows

$link = mysql_connect("localhost", "bla", "bla");
            mysql_select_db("db", $link);
            $result = mysql_query("SELECT * FROM narr_turnier_".$onlyconsonants." WHERE startnummer <> '0-1' and startnummer <> '0-2' startnummer <> '0-3' && turnier_jaar='$jaarnu'", $link);
$num_rowszondersterz = mysql_num_rows($resulttacz);

this gives me the folowing error

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in .... on line ...

thanks i advice
John

Edited by johnnyd1963

1
Contributor
1
Reply
2
Views
4 Years
Discussion Span
Last Post by johnnyd1963
0

Thanks if someone reads is i found the solution

    $link = mysql_connect("localhost", "bla", "bla");
            mysql_select_db("db", $link);
            $result = mysql_query("SELECT startnummer FROM narr_turnier_".$onlyconsonants." WHERE startnummer in ('0-1','0-2','0-3','0-4','0-5','0-6','0-7','0-8','0-9','0-10','0-11','0-12' ) && turnier_jaar='$jaarnu'", $link);
$num = mysql_num_rows($resulttacz);
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.