Warning: mysql_num_rows(): Системата на Миро за игри

L

lam3r4370

Registered
Значи като вляза в някоя категория и ми дава това Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lam3/public_html/games/sportni.php on line 55
1? Може ли някой да ми каже как да го оправя това? :) :?:
Ето го и кода
Код: 
<?php

ob_start();

include "config.php";

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">

<link href="style.css" rel="stylesheet" type="text/css">

<title>Онлайн игри</title>

</head>



<body>

<div id="container">

	<div id="header">

	</div>

	<div id="border">

		<div id="main">

			<div id="left">

				<div id="menu">

					<ul><?php include "login.php"; ?><br><div class="podmenu">Главно меню</div>

					<?php include "menu.html"; ?></ul>

					<ul><div class="podmenu">Търсачка:</div></ul>

					<?php include "search.html"; ?>

				</div>

		  </div>

			<div id="right">

				<div class="content">

					<a href="ekshan.php" class="navLink">Екшън</a>

					<a href="arkadni.php" class="navLink">Аркадни</a>

					<a href="logicheski.php" class="navLink">Логически</a>

					<a href="sportni.php" class="navLink">Спортни</a>

					<a href="zabavni.php" class="navLink">Забавни</a>

<table width="100%" border="0">

<tr>

<?php

$pp = "9"; 

//колко резултата на страница 

$page=$_GET['page'];

if(!$_GET['page'])

{ 

$page="1"; 

} 

$limit = ($pp*$page)-$pp;

mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111"); 

@mysql_select_db($dbname) or die("2222"); 

$redove=mysql_query("SELECT * FROM $table_name"); 

$max=mysql_numrows($redove);

$total=ceil($max/$pp);

mysql_connect($server, $dbusername, $dbpassword)or die("3333"); 

@mysql_select_db($dbname) or die("4444"); 

$query="SELECT * FROM $table_name WHERE kategoria='Екшън' ORDER BY id DESC LIMIT $limit,$pp"; 

$result=mysql_query($query); 

$num=mysql_num_rows($result);

mysql_close(); 

echo "<table border='0'><tr><td>"; 

$i=0; 

while ($i < $num) { 

$ime=mysql_result($result,$i,"ime"); 

$pic=mysql_result($result,$i,"pic"); 

$kategoria=mysql_result($result,$i,"kategoria"); 

$id=mysql_result($result,$i,"id");

echo "<div class='div'>

<a href='play.php?id=$id'>$ime</a><br>

<a href='play.php?id=$id'><img src='$pic' width='100' height='100' border='0'></a><br>

<br></div>

"; 

$i++; 

} 

echo "</td</tr></table>";

//от тук започва страницирането

if ($page > 1) { 

$prev = ($page - 1); 

echo "<a href=\"?page=$prev\" class='ppRa'>предишна</a> "; 

} 

else echo ""; 



if (!$page or ($page > $total)) { 

$page="1"; 

} 



if ($total < 10) { 

for($i=1 ; $i<=$total ; $i++) { 

if ( ($page)==$i ) { 

echo "<b>$i</b> "; 

} 

else { 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 

} 

else { 

for($i=1 ; $i<=3 ; $i++) { 

if ( ($page)==$i ) { 

echo "<b>$i</b>"; 

} 

else { 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 



if ($page <= 3) { 

if ($page == 3) echo "<a href=\"?page=4\" class='ppRa'>4</a> "; 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

if ($page == 5) $parva.= "<a href=\"?page=4\" class='ppRa'>4</a> "; 



if ( ($page == 4) or ($page == 5) ) { 

for ($i=$page; $i<=$page+1; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 



if ( ($page > 5) and ($page < ($total - 4)) ) { 

echo "... "; 

for ($i=$page-1; $i<=$page+1; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 



if ( $page > ($total - 5) ) { 

echo "... "; 

for ($i=$total-5; $i<=$total; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 

} 



if ($page < $total) { 

$next = ($page + 1); 

echo "<a href=\"?page=$next\" class='ppRa'>следваща</a>"; 

} 

else echo "";

?>

</tr>

</table>

			

				</div>

				<div class="product">

				</div>

			</div>

			<div class="clear"></div>

		</div>

	</div>

</div>	

</body>

</html>
ред 55 е
Код: 
$query="SELECT * FROM $table_name WHERE kategoria='Екшън' ORDER BY id DESC LIMIT $limit,$pp"; 

$result=mysql_query($query); 

$num=mysql_num_rows($result);

mysql_close();
 
Опа извинявайте,
Код: 
<?php

ob_start();

include "config.php";

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">

<link href="style.css" rel="stylesheet" type="text/css">

<title>Онлайн игри</title>

</head>



<body>

<div id="container">

	<div id="header">

	</div>

	<div id="border">

		<div id="main">

			<div id="left">

				<div id="menu">

					<ul><?php include "login.php"; ?><br><div class="podmenu">Главно меню</div>

					<?php include "menu.html"; ?></ul>

					<ul><div class="podmenu">Търсачка:</div></ul>

					<?php include "search.html"; ?>

				</div>

		  </div>

			<div id="right">

				<div class="content">

					<a href="ekshan.php" class="navLink">Екшън</a>

					<a href="arkadni.php" class="navLink">Аркадни</a>

					<a href="logicheski.php" class="navLink">Логически</a>

					<a href="sportni.php" class="navLink">Спортни</a>

					<a href="zabavni.php" class="navLink">Забавни</a>

<table width="100%" border="0">

<tr>

<?php

$pp = "9"; 

//колко резултата на страница 

$page=$_GET['page'];

if(!$_GET['page'])

{ 

$page="1"; 

} 

$limit = ($pp*$page)-$pp;

mysql_connect($dbhost, $dbusername, $dbpassword)or die("1111"); 

@mysql_select_db($dbname) or die("2222"); 

$redove=mysql_query("SELECT * FROM $table_name"); 

$max=mysql_numrows($redove);

$total=ceil($max/$pp);

mysql_connect($server, $dbusername, $dbpassword)or die("3333"); 

@mysql_select_db($dbname) or die("4444"); 

$query="SELECT * FROM $table_name WHERE kategoria='Екшън' ORDER BY id DESC LIMIT $limit,$pp"; 

$result=mysql_query($query); 

$num=mysql_num_rows($result);

mysql_close(); 

echo "<table border='0'><tr><td>"; 

$i=0; 

while ($i < $num) { 

$ime=mysql_result($result,$i,"ime"); 

$pic=mysql_result($result,$i,"pic"); 

$kategoria=mysql_result($result,$i,"kategoria"); 

$id=mysql_result($result,$i,"id");

echo "<div class='div'>

<a href='play.php?id=$id'>$ime</a><br>

<a href='play.php?id=$id'><img src='$pic' width='100' height='100' border='0'></a><br>

<br></div>

"; 

$i++; 

} 

echo "</td</tr></table>";

//от тук започва страницирането

if ($page > 1) { 

$prev = ($page - 1); 

echo "<a href=\"?page=$prev\" class='ppRa'>предишна</a> "; 

} 

else echo ""; 



if (!$page or ($page > $total)) { 

$page="1"; 

} 



if ($total < 10) { 

for($i=1 ; $i<=$total ; $i++) { 

if ( ($page)==$i ) { 

echo "<b>$i</b> "; 

} 

else { 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 

} 

else { 

for($i=1 ; $i<=3 ; $i++) { 

if ( ($page)==$i ) { 

echo "<b>$i</b>"; 

} 

else { 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 



if ($page <= 3) { 

if ($page == 3) echo "<a href=\"?page=4\" class='ppRa'>4</a> "; 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

if ($page == 5) $parva.= "<a href=\"?page=4\" class='ppRa'>4</a> "; 



if ( ($page == 4) or ($page == 5) ) { 

for ($i=$page; $i<=$page+1; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 



if ( ($page > 5) and ($page < ($total - 4)) ) { 

echo "... "; 

for ($i=$page-1; $i<=$page+1; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

echo "... "; 

for ($i=$total-2; $i<=$total; $i++) 

echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 



if ( $page > ($total - 5) ) { 

echo "... "; 

for ($i=$total-5; $i<=$total; $i++) { 

if ($page == $i) echo "<b>$i</b> "; 

else echo "<a href=\"?page=".$i."\" class='ppRa'>".$i."</a> "; 

} 

} 

} 



if ($page < $total) { 

$next = ($page + 1); 

echo "<a href=\"?page=$next\" class='ppRa'>следваща</a>"; 

} 

else echo "";

?>

</tr>

</table>

			

				</div>

				<div class="product">

				</div>

			</div>

			<div class="clear"></div>

		</div>

	</div>

</div>	

</body>

</html>
ред 55 е
Код: 
$query="SELECT * FROM $table_name WHERE kategoria='Екшън' ORDER BY id DESC LIMIT $limit,$pp"; 

$result=mysql_query($query); 

$num=mysql_num_rows($result);

mysql_close();
 
emagi каза:
Сигурен ли си ,че масива:
$result=mysql_query($query);
Увеличете...
има нещо!
Я дай едно:
print_r ($result);
Увеличете...
Няма страшно, и да ти се рамести дизайна!САмо да видим какво ще изведе, дали изобщо от заявката "излиза" нещо!
Или дай:
mysql_error()
Увеличете...
след завката
Увеличете...
на print_r ($result); и на mysql_error() не ми излиза нищо
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Горе