Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
C++ JAVA
-
lam3r4370
- Шаман
- Posts: 3424
- Joined: Wed Aug 20, 2008 4:12 pm
-
Answers: 131
Post
by lam3r4370 » Wed Sep 24, 2008 10:59 am
Значи като вляза в някоя категория и ми дава това 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? Може ли някой да ми каже как да го оправя това?
Ето го и кода
Code: Select all
<?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 е
Code: Select all
$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();
Last edited by
lam3r4370 on Wed Sep 24, 2008 11:49 am, edited 1 time in total.
-
emagi
- Шаман
- Posts: 6476
- Joined: Fri Dec 07, 2007 3:24 pm
-
Answers: 1032
Post
by emagi » Wed Sep 24, 2008 11:24 am
е дай целия файл!
-
lam3r4370
- Шаман
- Posts: 3424
- Joined: Wed Aug 20, 2008 4:12 pm
-
Answers: 131
Post
by lam3r4370 » Wed Sep 24, 2008 11:47 am
Опа извинявайте,
Code: Select all
<?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 е
Code: Select all
$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();
-
lortnoc
- Турист
- Posts: 545
- Joined: Mon Jul 09, 2007 4:57 am
-
Answers: 125
- Location: Пловдив
Post
by lortnoc » Wed Sep 24, 2008 11:57 am
Last edited by
lortnoc on Wed Sep 24, 2008 12:03 pm, edited 1 time in total.
-
emagi
- Шаман
- Posts: 6476
- Joined: Fri Dec 07, 2007 3:24 pm
-
Answers: 1032
Post
by emagi » Wed Sep 24, 2008 11:58 am
Сигурен ли си ,че масива:
$result=mysql_query($query);
има нещо!
Я дай едно:
print_r ($result);
Няма страшно, и да ти се рамести дизайна!САмо да видим какво ще изведе, дали изобщо от заявката "излиза" нещо!
Или дай:
mysql_error()
след завката
-
lam3r4370
- Шаман
- Posts: 3424
- Joined: Wed Aug 20, 2008 4:12 pm
-
Answers: 131
Post
by lam3r4370 » Thu Sep 25, 2008 10:19 am
emagi wrote:Сигурен ли си ,че масива:
$result=mysql_query($query);
има нещо!
Я дай едно:
print_r ($result);
Няма страшно, и да ти се рамести дизайна!САмо да видим какво ще изведе, дали изобщо от заявката "излиза" нещо!
Или дай:
mysql_error()
след завката
на print_r ($result); и на mysql_error() не ми излиза нищо
