Dlaczego xampp wyrzuca mi taki error :
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in E:\xamp\htdocs\search\index.php on line 20
Dorzucam kod źródłowy:
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Index</title>
</head>
<body>
<form method="post" action="index.php">
<input type="text" name="search" placeholder="search">
<input type="submit" name="post" value="search">
</form>
<?php
include_once("db.php");
if (isset($_POST['search'])) {
$searching = $_POST['search'];
$searching = preg_replace("#[^0-9a-z]#i", "", $searching);
$query = mysql_query("SELECT * FROM users WHERE fname LIKE '%$searching%' OR lname LIKE '%$searching%'");
$count = mysql_num_rows($query);
if ($count >= 0) {
$output = "error";
}else {
while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
$fname = $row['fname'];
$lname = $row['lname'];
$output .= '<div>' . $fname . $lname . '</div>';
}
}
echo $output;
}
?>
</body>
</html>