Archief - PHP: mysql_num_rows(): supplied argument is not a valid MySQL result

<table class="list_table">
	<tr>
		<td>Titel</td>
		<td>Playtime</td>
		<td>Genre</td>
	</tr>
<?php
	$db = mysql_connect('localhost', 'dekadee_root', 'Pa$$op');
	mysql_select_db('dvd', $db);
	$query = "select * from lijst order by titel";
	$result = mysql_query($query);
	$num = mysql_num_rows($result);
	mysql_close();
	$i = 0;
	while ($i < $num) {
		print("\t<tr class=\"list_tr\" onclick=\"parent.location='?content=detail&amp;id=" . mysql_result($result, $i, 'id') . "';\" onmouseover=\"this.style.backgroundColor='rgb(220,220,220)';\" onmouseout=\"this.style.background='none';\">\n");
		print("\t\t<td>" . htmlentities(mysql_result($result, $i, 'titel')) . "</td>\n");
		if (mysql_result($result, $i, 'time') == null)
			print("\t\t<td></td>\n");
		else {
			$time = mysql_result($result, $i, 'time');
			$time2 = floor($time / 60) . ":";
			$time = $time % 60;
			if (strlen($time) == 1) $time = 0 . $time;
				$time2 .= $time;
			print("\t\t<td>" . $time2 . "</td>\n");
		}
		print("\t\t<td>" . mysql_result($result, $i, 'genre') . "</td>\n");
		print("\t</tr>\n");
		$i++;
	}                
?>
</table>

$result = mysql_query($query) or die(mysql_error());

<?php	
	if (isset($action)) {
		if ($action == "yes") {
			$db = mysql_connect('localhost', 'verborgen', 'verborgen');
			mysql_select_db('verborgen', $db);
			$query = "verborgen";
			mysql_query($query);
			mysql_close();
			header("Location: verborgen");
		}
		if ($action == "no") 
			header("Location: verborgen");
	}
	else {

		print("<div class=\"delete\">\n");
		print("\tDelete:\n");
		print("</div>\n");

		print("Are you sure you want to delete:<br />\n");
		$db = mysql_connect('localhost', 'verborgen', 'verborgen');
		mysql_select_db('verborgen', $db);
		$query = "verborgen";
		$result = mysql_query($query);
		mysql_close();
		print("<span class=\"delete_film\">" . mysql_result($result, 0, 'titel') . "</span>\n");
		print("<br /><br /><span class=\"delete_menu\"><a href=\"?content=delete&id=" . $id . "&action=yes\">Yes</a>");
		print(" | <a href=\"?content=delete&id=" . $id . "&action=no\">No</a><span>");
	}
?>