Проблем с mysql_num_rows() и mysql_fetch_assoc()

kristiqn2

Registered
Мисля че по заглавието се разбира
ето ги и проблемите:
Код:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\CS\head.php on line 221
Код:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\CS\head.php on line 220
 
mysql_query не е върнало валиден ресурс, имаш нещо грешно в заявката. Сложи след:

mysql_query(...) or die(mysql_error());

виж и си оправи грешката.
 
за да го дебъгнеш каде ти е грешката прибнтни си заявката и виж дали всичко и е наред пример:
PHP:
echo $query;
 
Благодаря оправих се но се появи друг проблем в админ панела:
когато опитам направя нещо и ми излиза това:

ето го и кода:
Код:
<?
$our = mysql_query("SELECT * FROM servers"); 
while($raw=mysql_fetch_array or die(mysql_error())
 
echo '<tr><td>'.$raw['servname'].'</td><td>'.$raw['servver'].'</td><td><a href="cpanel.php?page=servers&ext=edit&id='.$raw['id'].'">Промени!</а></td><td><a href="cpanel.php?page=servers&ext=delete&id='.$raw['id'].'">Изтрий!</а></td></tr>';
?>
Ето го и целия код:
Код:
<?
if (eregi("modules/servers/index.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
?>

<b>
<br><br><a href="cpanel.php?page=index"><<< Върни се към Админ Панела</a><br><br><a href="cpanel.php?page=servers&ext=add">Добави Сървър</a><br><br>
<table border="1">
<tr>
 <td>Име на сървъра:</td>
 <td>Версия:</td>
 <td>Промени?</td>
 <td>Изтрий?</td>
</tr>
<?
$our = mysql_query("SELECT * FROM servers"); 
while($raw=mysql_fetch_array or die(mysql_error())
 
echo '<tr><td>'.$raw['servname'].'</td><td>'.$raw['servver'].'</td><td><a href="cpanel.php?page=servers&ext=edit&id='.$raw['id'].'">Промени!</а></td><td><a href="cpanel.php?page=servers&ext=delete&id='.$raw['id'].'">Изтрий!</а></td></tr>';
?>
</table>

</b>
 
пробвай така


PHP:
<?
if (eregi("modules/servers/index.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
?>

<b>
<br><br><a href="cpanel.php?page=index"><<< Върни се към Админ Панела</a><br><br><a href="cpanel.php?page=servers&ext=add">Добави Сървър</a><br><br>
<table border="1">
<tr>
 <td>Име на сървъра:</td>
 <td>Версия:</td>
 <td>Промени?</td>
 <td>Изтрий?</td>
</tr>
<?
$our = mysql_query("SELECT * FROM servers");
while($raw=mysql_fetch_array($our))
 {
echo '<tr><td>'.$raw['servname'].'</td><td>'.$raw['servver'].'</td><td><a href="cpanel.php?page=servers&ext=edit&id='.$raw['id'].'">Промени!</а></td><td><a href="cpanel.php?page=servers&ext=delete&id='.$raw['id'].'">Изтрий!</а></td></tr>';
 }
?>
</table>

</b>
грешката е в
PHP:
 while($raw=mysql_fetch_array ($our))
 
оххх :) недоглеждане

PHP:
<?
if (eregi("modules/servers/index.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied!"); }
?>

<b>
<br><br><a href="cpanel.php?page=index"><<< Върни се към Админ Панела</a><br><br><a href="cpanel.php?page=servers&ext=add">Добави Сървър</a><br><br>
<table border="1">
<tr>
 <td>Име на сървъра:</td>
 <td>Версия:</td>
 <td>Промени?</td>
 <td>Изтрий?</td>
</tr>
<?
$our = "SELECT * FROM servers";
$sql = mysql_query( $sql) or die(mysql_error());
while($raw=mysql_fetch_array($our))
 {
echo '<tr><td>'.$raw['servname'].'</td><td>'.$raw['servver'].'</td><td><a href="cpanel.php?page=servers&ext=edit&id='.$raw['id'].'">Промени!</а></td><td><a href="cpanel.php?page=servers&ext=delete&id='.$raw['id'].'">Изтрий!</а></td></tr>';
 }
?>
</table>

</b>
 
Благодаря стана! :)
но последно да питам да не правя нова тема в самия сайт LGSL е от ляво.
Та въпроса ми е как да го преместя от дясно ?
 
зависи в какво си го сложил,ама най вероятно ще стане с

Код:
align="right"
 
http://store.picbg.net/thumb/4A/8C/392c9bf6fd844a8c.bmp
:(
ето кода къде точно трябва да го сложа?
Код:
<? ob_start(); ?>
<? session_start(); ?>
<?php include "config.php"; ?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="bg" lang="bg" dir="ltr">
		<head>
			<title><? echo $title ?> // Начало</title>
	<?php include ("META.php"); ?>  
			<link rel="stylesheet" type="text/css" href="css/style.css" />
			<link rel="shortcut icon" href="images/favicon.ico" />
	 
		</head>
  <body>
 
   <div id="toolbar">
	<div id="sites">

	
	



	</div>

</div>

  <table width="965" border="0" align="center" cellpadding="2" cellspacing="2" id="cont">
  <tr>
    <td colspan="3">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
	
    <td width="45%" valign="top"><a href="index.php"><img src="images/headers.jpg" alt="sharebg.net" width="400" height="120" border="0" /></a></td>
    <td width="55%">   <div id="hedads">

   <a href="http://cs-escom.com/" target="_blank" title="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."><img src="http://cs-escom.com/images/cs-escomb1.png" border="0" alt="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."></a>

   
</div></td>
    
	</tr>
    </table>
    </td>
    </tr>
    <tr>
    <td colspan="3">

	
    <div id="navbar">
		<?php include ("MENU.php"); ?>  

    </div>
	
	</td>
    </tr>  
	<tr>
    <td width="20%" valign="top">
	
       
  <table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2" align="right">
  <tr>

  <td class="menubg" align="right">Сървъри</td>
  </tr>
  <tr>
  <td class="menubrd" align="right">
	
	
		<?php require("lgsl/lgsl_module.php"); ?>


	</td>
    </tr>
</table>
<table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2">
  <tr>
  <td class="menubg">Вход в системата</td>
  </tr>
  <tr>
  <td class="menubrd" align="center">
  
<?php
		$id = $_GET['id'];
		$logged_id = $_SESSION['userinfo']['id'];
		$sql = "SELECT * FROM `users` WHERE id='$logged_id'";
		$result = mysql_query($sql);
		$data = mysql_fetch_assoc($result);
		if($_SESSION['logged']===true) {
		if($_SESSION['userinfo']['rank']!=3) {
		// member menu::
		?>
		<div id="menu">
		<ul>
		<li><a id="current" href="index.php">Начало</a></li>
		<li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
		<li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
		<li><a href="logout.php">Изход</a></li>	
		<? if($_SESSION['userinfo']['rank']!=3) {
		echo "</div>";
		}
		?>
		<?
		}
		if($_SESSION['userinfo']['rank']==3) {
		// plus menus for admin ::
		?>
		<div id="menu">
		<ul>
		<li><a href="adm/index.php">Админ панел</a></li>
		<li><a id="current" href="index.php">Начало</a></li>
		<li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
		<li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
		<li><a href="logout.php">Изход</a></li>
		</ul>
		</div>
		<?
		}
		}
		else {
		include "login.php";
		}
		?>

  	
  
  
  
  
  </td>

</tr>
</table>
<table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2" >
  <tr>
    <td width="179" class="menubg">Реклама</td>
  </tr>
  <tr>
    <td class="menubrd" align="center">




   
</td>
  </tr>

</table>	
    	
    </td><td width="80%" valign="top" align="center">
    
	<table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2" align="">
    <tr>
    <td class="menubg">Реклама</td>
	
    </tr>
    <tr>
    <td class="menubrd" align="center">
<center>

<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</center>
    </td>
    </tr>
    </table>
    <table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
  <tr>

    <td class="menubg"> Новини </td>
	
    </tr>

  <tr>

    <td class="menubrd">
	
	
	
	
	
	
	

	</td>
    </tr>
</table>



<table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
  <tr>
    <td class="menubg">  Реклама </td>

    </tr>

  <tr>

    <td class="menubrd" align="center">
	  
 <center>

<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</center>
 
</td>
</tr>
</table>
<br />

	

    </td>
    </tr>
    <tr>
	
    <td colspan="3">
    <div align="center" class="fooms">
    <br />
    <b>Гейминг.info / Gaming Bulgaria © 2009</b>  <br /> <br />

   
    </div>
	</td>
    </tr>
  </table>

  </body>
    </html>
 
направи си една таблица в дясната част на сайта и оразмери всички таблици по процента по който да ти се появяват и всичко ще е наред :)
 
така? :

PHP:
<? ob_start(); ?>
<? session_start(); ?>
<?php include "config.php"; ?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="bg" lang="bg" dir="ltr">
      <head>
         <title><? echo $title ?> // Начало</title>
   <?php include ("META.php"); ?>  
         <link rel="stylesheet" type="text/css" href="css/style.css" />
         <link rel="shortcut icon" href="images/favicon.ico" />
   
      </head>
  <body>
 
   <div id="toolbar">
   <div id="sites">

   
   



   </div>

</div>

  <table width="965" border="0" align="center" cellpadding="2" cellspacing="2" id="cont">
  <tr>
    <td colspan="3">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
   
    <td width="45%" valign="top"><a href="index.php"><img src="images/headers.jpg" alt="sharebg.net" width="400" height="120" border="0" /></a></td>
    <td width="55%">   <div id="hedads">

   <a href="http://cs-escom.com/" target="_blank" title="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."><img src="http://cs-escom.com/images/cs-escomb1.png" border="0" alt="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."></a>

   
</div></td>
    
   </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td colspan="3">

   
    <div id="navbar">
      <?php include ("MENU.php"); ?>  

    </div>
   
   </td>
    </tr> 
   <tr>
    <td width="20%" valign="top">
   

   <table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2">
     <tr>
  <td class="menubg">Вход в системата</td>
  </tr>
  <tr>
  <td class="menubrd" align="center">
 
<?php
      $id = $_GET['id'];
      $logged_id = $_SESSION['userinfo']['id'];
      $sql = "SELECT * FROM `users` WHERE id='$logged_id'";
      $result = mysql_query($sql);
      $data = mysql_fetch_assoc($result);
      if($_SESSION['logged']===true) {
      if($_SESSION['userinfo']['rank']!=3) {
      // member menu::
      ?>
      <div id="menu">
      <ul>
      <li><a id="current" href="index.php">Начало</a></li>
      <li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
      <li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
      <li><a href="logout.php">Изход</a></li>   
      <? if($_SESSION['userinfo']['rank']!=3) {
      echo "</div>";
      }
      ?>
      <?
      }
      if($_SESSION['userinfo']['rank']==3) {
      // plus menus for admin ::
      ?>
      <div id="menu">
      <ul>
      <li><a href="adm/index.php">Админ панел</a></li>
      <li><a id="current" href="index.php">Начало</a></li>
      <li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
      <li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
      <li><a href="logout.php">Изход</a></li>
      </ul>
      </div>
      <?
      }
      }
      else {
      include "login.php";
      }
      ?>

     
 
 
 
 
  </td>

</tr>
</table>
<table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2" >
  <tr>
    <td width="179" class="menubg">Реклама</td>
  </tr>
  <tr>
    <td class="menubrd" align="center">




   
</td>
  </tr>

</table>   
       
    </td><td width="80%" valign="top" align="center">
    
   <table width="61%" class="menuside" border="0" cellspacing="2" cellpadding="2" align="">
    <tr>
    <td class="menubg">Реклама</td>
   
    </tr>
    <tr>
    <td class="menubrd" align="center">
<center>

<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</center>
    </td>
    </tr>
    </table>
    <table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
  <tr>

    <td class="menubg"> Новини </td>
   
    </tr>

  <tr>

    <td class="menubrd">
   
   
   
   
   
   
   

   </td>
    </tr>
</table>



<table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
  <tr>
    <td class="menubg">  Реклама </td>

    </tr>

  <tr>

    <td class="menubrd" align="center">
    
 <center>

<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</center>
 
</td>
</tr>
  <tr>

  <td class="menubg" align="right">Сървъри</td>
  </tr>
  <tr>
  <td class="menubrd" align="right">
   
   
      <?php require("lgsl/lgsl_module.php"); ?>


   </td>
</table>
<br />

   

    </td>
    </tr>
    <tr>
   
    <td colspan="3">
    <div align="center" class="fooms">
    <br />
    <b>Гейминг.info / Gaming Bulgaria © 2009</b>  <br /> <br />

   
    </div>
   </td>
    </tr>
  </table>

  </body>
    </html>
 
трябва да си оправш таблицата на страницата, не е подредена добре ето ти една корекция незнам дали ще работи нормално

PHP:
<? ob_start(); ?>
<? session_start(); ?>
<?php include "config.php"; ?>
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="bg" lang="bg" dir="ltr">
      <head>
         <title><? echo $title ?> // Начало</title>
   <?php include ("META.php"); ?>  
         <link rel="stylesheet" type="text/css" href="css/style.css" />
         <link rel="shortcut icon" href="images/favicon.ico" />
   
      </head>
  <body>
 
   <div id="toolbar">
   <div id="sites">

   
   



   </div>

</div>

  <table width="965" border="0" align="center" cellpadding="2" cellspacing="2" id="cont">
  <tr>
    <td colspan="3">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
   
    <td width="45%" valign="top"><a href="index.php"><img src="images/headers.jpg" alt="sharebg.net" width="400" height="120" border="0" /></a></td>
    <td width="55%">   <div id="hedads">

   <a href="http://cs-escom.com/" target="_blank" title="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."><img src="http://cs-escom.com/images/cs-escomb1.png" border="0" alt="CS-ESCOM всичко за Counter Strike - сървъри, ботове, пачове ..."></a>

   
</div></td>
    
   </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td colspan="3">

   
    <div id="navbar">
      <?php include ("MENU.php"); ?>  

    </div>
   
   </td>
    </tr> 
    <tr>
    <td><table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <td class="menubg">Вход в системата</td>
      </tr>
      <tr>
        <td class="menubrd" align="center"><?php
      $id = $_GET['id'];
      $logged_id = $_SESSION['userinfo']['id'];
      $sql = "SELECT * FROM `users` WHERE id='$logged_id'";
      $result = mysql_query($sql);
      $data = mysql_fetch_assoc($result);
      if($_SESSION['logged']===true) {
      if($_SESSION['userinfo']['rank']!=3) {
      // member menu::
      ?>
          <div id="menu">
          <ul>
          <li><a id="current" href="index.php">Начало</a></li>
          <li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
          <li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
          <li><a href="logout.php">Изход</a></li>
          <? if($_SESSION['userinfo']['rank']!=3) {
      echo "</div>";
      }
      ?>
          <?
      }
      if($_SESSION['userinfo']['rank']==3) {
      // plus menus for admin ::
      ?>
          <div id="menu">
            <ul>
              <li><a href="adm/index.php">Админ панел</a></li>
              <li><a id="current" href="index.php">Начало</a></li>
              <li><a href="<?php echo "view.php?id=$data[id]" ?>">Моят профил</a></li>
              <li><a href="<?php echo "edit.php?id=$data[id]" ?>">Промяна профил</a></li>
              <li><a href="logout.php">Изход</a></li>
            </ul>
          </div>
          <?
      }
      }
      else {
      include "login.php";
      }
      ?></td>
      </tr>
    </table>
      <table width="194" class="menuside" border="0" cellspacing="2" cellpadding="2" >
        <tr>
          <td width="179" class="menubg">Реклама</td>
        </tr>
        <tr>
          <td class="menubrd" align="center"></td>
        </tr>
      </table></td>
    <td align="center" valign="top"><table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2" align="">
      <tr >
        <td class="menubg">Реклама</td>
      </tr>
      <tr>
        <td class="menubrd" align="center"><center>
          <script type="text/javascript">
    </script>
          <script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
    </script>
        </center></td>
      </tr>
    </table></td>
    <td width="19%"><table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <td class="menubg"> Новини </td>
      </tr>
      <tr>
        <td class="menubrd"></td>
      </tr>
    </table>
      <table width="100%" class="menuside" border="0" cellspacing="2" cellpadding="2">
        <tr>
          <td class="menubg"> Реклама </td>
        </tr>
        <tr>
          <td class="menubrd" align="center"><center>
            <script type="text/javascript">
            </script>
            <script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
            </script>
          </center></td>
        </tr>
        <tr>
          <td class="menubg" align="right">Сървъри</td>
        </tr>
        <tr>
          <td class="menubrd" align="right"><?php require("lgsl/lgsl_module.php"); ?></td>
        </tr>
      </table></td>
    </tr>
   <tr>
    <td width="21%" valign="top">
      
    </td><td width="60%" valign="top" align="center">
    <br />

   

    </td>
    </tr>
    <tr>
   
    <td colspan="3">
    <div align="center" class="fooms">
    <br />
    <b>Гейминг.info / Gaming Bulgaria © 2009</b>  <br /> <br />

   
    </div>
   </td>
    </tr>
  </table>

  </body>
    </html>
 
Пак не става.
Моля ви няма ли кой да ми оправи кода трябва ми много спешно :(
 
дай снимка да вида как излиза
сори ама така е малко работа на магия без DB и CSS
 
Аз се оправих благодаря все пак но ми дава една грешка:
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\register.php:9) in C:\xampp\htdocs\login.php on line 18
 
кода на login.php
или погледни дали там нямаш пак
PHP:
<? ob_start(); ?>
<? session_start(); ?>
 

Back
Горе