Fejlmeddelelse: Undefined variable og mysql_num_rows() expects parameter 1 to be resource, null given in...
Hej.Jeg har fået et problem efter jeg har installeret WampServer 2.0i, den kommer med en fejlmeddelelse der hedder:
Notice: Undefined variable: rows3 in F:\wamp\www\dvd\antal_dvd.php on line 13
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in F:\wamp\www\dvd\antal_dvd.php on line 13
Notice: Undefined variable: rows1 in F:\wamp\www\dvd\antal_dvd.php on line 15
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in F:\wamp\www\dvd\antal_dvd.php on line 15
Min kode ser sådan ud:
<table id="antaldvd" border="0" align="center">
<tr>
<td>
<?php
$rows = '';
$rows1 = '';
$rows2 = '';
$rows3 = '';
if($_SESSION['admin'] == 3){
$rows1 = mysql_query("SELECT * FROM film WHERE original_kopi LIKE 'Original'");
$rows3 = mysql_query("SELECT * FROM film WHERE dvd_bluray LIKE 'blu_ray.jpg' AND original_kopi LIKE 'Original'");
} else {
$rows = mysql_query("SELECT * FROM film WHERE dvd_bluray LIKE 'blu_ray.jpg'");
$rows2 = mysql_query("SELECT * FROM film WHERE dvd_bluray LIKE 'dvd.jpg'");
}
//Linie 13// $antal_blu_ray_org = mysql_num_rows($rows3);
$antal_dvd = mysql_num_rows($rows2);
//Linie 15// $antal_dvd_org = mysql_num_rows($rows1);
$antal_blu_ray = mysql_num_rows($rows);
$ialt_org = $antal_dvd_org - $antal_blu_ray_org;
$ialt = $antal_dvd - $antal_blu_ray;
$totalt = $antal_dvd + $antal_blu_ray;
if($_SESSION['admin'] == 3){echo "<td>Der er <a href='/dvd/alle_blu_ray_film.php'>$antal_blu_ray_org</a> Blu-Ray film og <a href='/dvd/alle_dvd_film.php'>$ialt_org</a> DVD film i databasen</td>";} else {
echo "<td align=\"Center\">Der er <a href='/dvd/alle_blu_ray_film.php'>$antal_blu_ray</a> Blu-Ray film og <a href='/dvd/alle_dvd_film.php'>$antal_dvd</a> DVD film.<br>I alt $totalt film i databasen.</td>";}
?>
</td>
</tr>
</table>
Ved I evt. hvad det kan være? Jeg har stirret mig helt blind på det... ;-)
Hilsen Brian.
