| jonssondesign |
2012-09-07 14:07 |
Felmeddelande sql
Hej, förstår inte riktigt varför jag får detta felmeddelande.. Kanske någon av er ser vad som är fel?
Felmeddelande: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\Program Files\xampp\htdocs\reaplagg\admin\kommentarer.php on line 20
kod
PHP-kod:
if (isset($_GET['search'])) {
$search = mysql_real_escape_string($_GET['search']);
if (strlen($search) <= 3) {
$query = "SELECT * FROM comments WHERE (user_name LIKE '%$search%') ";
} else {
$query = "SELECT * FROM comments WHERE MATCH(user_name) AGAINST ('+$search' IN BOOLEAN MODE) ";
};
} else {
$query = "SELECT * FROM comments ";
};
$result = mysql_query($query);
$items = 20; // number of items per page.
$num_rows = mysql_num_rows($result);
$nrpage_amount = $num_rows/$items;
$page_amount = ceil($num_rows/$items);
$page_num = ceil($num_rows/$items);
if (isset($_GET['p'])) { $page = mysql_real_escape_string($_GET['p']); } else { $page = 1; };
$p_num = $items*($page-1);
$query .= "ORDER BY added DESC ";
$query .= "LIMIT $p_num , $items";
$result = mysql_query($query);
?>
Jag har en nästan exakt likadan kod på en annan sida, men som hämtar ut data från annan databas och annan column.
kod:
PHP-kod:
if (isset($_GET['search'])) {
$search = mysql_real_escape_string($_GET['search']);
if (strlen($search) <= 3) {
$query = "SELECT * FROM products WHERE (title LIKE '%$search%' OR brand LIKE '%$search%' OR category LIKE '%$search%') ";
} else {
$query = "SELECT * FROM products WHERE MATCH(title, brand, category) AGAINST ('+$search' IN BOOLEAN MODE) ";
};
} else {
$query = "SELECT * FROM products ";
};
$result = mysql_query($query);
$items = 20; // number of items per page.
$num_rows = mysql_num_rows($result);
$nrpage_amount = $num_rows/$items;
$page_amount = ceil($num_rows/$items);
$page_num = ceil($num_rows/$items);
if (isset($_GET['p'])) { $page = mysql_real_escape_string($_GET['p']); } else { $page = 1; };
$p_num = $items*($page-1);
$query .= "ORDER BY added DESC ";
$query .= "LIMIT $p_num , $items";
$result = mysql_query($query);
Ser ni varför det blir fel? Har jag kanske glömt något?
produkt tabellen har dessa kolumner:
id img title brand store price org_price url added category gender visible info clicks advertiserProductUrl
kommentar tabellen har dessa kolumner:
id product_id comment user_name user_email user_url added |
