whats the error??

eaglelegend · October 21, 2008

Sorry I am unsure what the error is, could it be missing entry in the database, coding error, what!? please help, thanks!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /PATH/viewstat.php on line 29

ViewStat.php

<?php
include "logincheck.php";
include_once "config.php";
include_once "left_mem.php";

function main()
{

$strpass="";

if ( isset($_REQUEST["id"] ) )
{
$strpass=$strpass . "&id=" . $_REQUEST["id"];
}
$rs0=mysql_fetch_array(mysql_query("select * from config"));
$recperpage=$rs0["recperpage"];
$sql="select *,UNIX_TIMESTAMP(date_submitted) as ds,UNIX_TIMESTAMP(date_approved) as da from sbwmd_softwares where uid=".$_SESSION["userid"];
$sql.= " order by popularity desc" ;
$rs_query=mysql_query($sql);
///////////////////////////////////PAGINATION /////////
if(!isset($_REQUEST["pg"]))
{
		$pg=1;
}
else 
{
$pg=$_REQUEST["pg"];
}
$rcount=mysql_num_rows($rs_query);
if ($rcount==0 )
{ 
$pages=0;
}	
else
{
$pages=floor($rcount / $recperpage);
if  (($rcount%$recperpage) > 0 )
{
	$pages=$pages+1;
}
}
$jmpcnt=1;
while ( $jmpcnt<=($pg-1)*$recperpage  && $row = mysql_fetch_array($rs_query) )
    {	
	$jmpcnt = $jmpcnt + 1;
}

////////////////////////////////////////////////////////////////////////
?>

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

<?php
$rs0=mysql_fetch_array(mysql_query("select * from members where id=".$_SESSION["userid"]));
?>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" dwcopytype="CopyTableRow">
  <tr> 
    <td valign="top"> </td>
  </tr>
  <tr> 
    <td height="25"><a href="index.php"  class="barlink"><font color="#000000"><strong>HOME</strong> 
      </font></a> <font color="#000000">><strong> SOFTWARE STATISTICS</font></font></strong></font>
      <hr size="1"></td>
  </tr>
  <tr> 
    <td valign="top"> </td>
  </tr>
  <tr> 
    <td valign="top"> </td>
  </tr>
  <tr> 
    <td valign="top"> <table width="95%" border="0" cellpadding="0" cellspacing="0">
        <tr align="center" valign="middle" bgcolor="#003366"> 
          <td height="25"><strong><font color="#FFFFFF" size="1" >Name</font></strong></td>
          <td height="25"><strong><font color="#FFFFFF" size="1" >Rating</font></strong></td>
          <td height="25"><strong><font color="#FFFFFF" size="1" >Popularity</font></strong></td>
          <td height="25"><strong><font color="#FFFFFF" size="1" >Downloads</font></strong></td>
          <td height="25"><strong><font color="#FFFFFF" size="1" >Clicks</font></strong></td>
          <td height="25"><strong><font color="#FFFFFF" size="1" >Page 
            Views </font></strong></td>
          <td><strong><font color="#FFFFFF" size="1" >Rating 
            Code </font></strong></td>
        </tr>
        <?php
			if ($pages==0)
				{
			?>
        <tr > 
          <td colspan=7> <div align="center"> <br>
              <table width= 100% align="center" bgcolor="#C8C8C8" bordercolor="#ffffff" border="0" cellpadding="5" >
                <tr> 
                  <td><div align="center"><b><font face="verdana, arial" size="1" color="#000000"> 
                      No listing entries satisfy the criteria you specified. </font></b></div></td>
                </tr>
              </table>
            </div></td>
        </tr>
        <?php
			echo "</table>";
			}
			else
			{
			?>
        <?php
  				$cnt=0;
			while (($rs0=mysql_fetch_array($rs_query)) && $cnt<$recperpage )
			{
		     ?>
        <tr align="center" valign="middle"> 
          <td height="19"><div align="left"><a target="other" href="software-description.php?id=<?php echo $rs0["id"]; ?>" class="insidelink"><?php echo $rs0["s_name"];?> 
              </a></div></td>
          <td> 
            <?php
			$avgrat=0.0;
			$rating=mysql_fetch_array(mysql_query("select count(rating) as cnt,sum(rating) as sum from sbwmd_ratings where sid=".$rs0["id"]));
			if($rating["cnt"]<>0)
			$avgrat=$rating["sum"]/$rating["cnt"];
			else
			$avgrat=0.0;
			$avgrat/=2;
			$no_stars=0;
			$no_stars=abs($avgrat+0.5);
			if($avgrat >=($no_stars+0.5))
			$no_stars+=1;
			$i=1;
			while($i<6)
			{ $i++;
			  if($i<=$no_stars)
			  {
			?>
            <img src="images/star1.gif" width="8" height="7"> 
            <?php
			   }
			   else
			   {
			   ?>
            <img src="images/star2.gif" width="8" height="7"> 
            <?php
				}
			}	
			?>
          </td>
          <td> 
            <?php
			$pop=$rs0["popularity"]+40;
			$no_green=$pop/3;	
			$i=1;
			while($i<30)
			{ $i++;
			  if($i<=$no_green)
			  {
			  echo "<img src='images/pop1.gif' width='2' height='3'>"; 
            	   }
			   else
			   { 
			   echo "<img src='images/pop2.gif' width='2' height='3'>"; 
            		}
			}	
			?>
          </td>
          <td><?php echo $rs0["downloads"];?></td>
          <td><?php echo $rs0["hits_dev_site"];?></td>
          <td><?php echo $rs0["page_views"];?></td>
          <td><a href="rating_code.php?id=<?php echo $rs0["id"]; ?>" class="insidelink">Get 
            Code</a></td>
        </tr>
        <?php
		$cnt=$cnt+1;

		}//while
		$cnt=0;
		?>
      </table>
      <?php
		}// else
		?>
    </td>
  </tr>
  <tr> 
    <TD> <DIV align=center>
        <?php
if ($pages>1) 
{
?>
        <TABLE cellSpacing=0 cellPadding=0 border=0>
          <TBODY>
            <TR> 
              <TD width=42> 
                <?php



		if ($pg!=1)



		{



		?>
                <a href="viewstat.php?pg=<?php echo ($pg-1); ?><?php echo "$strpass"; ?>" > 
                <?php



		 }



		?>
                <?php



		if ($pg!=1)



		{



		?>
                </a> 
                <?php 



		} 



		?>
              </TD>
              <TD>Page</TD>
              <TD><IMG height=1 alt="" 
                                src="images/pix.gif" width=4 
                                border=0></TD>
              <TD><B><FONT color=#191970><?php echo $pg ;?> </FONT></B></TD>
              <TD><IMG height=1 alt="" 
                                src="images/pix.gif" width=4 
                                border=0></TD>
              <TD>of</TD>
              <TD><IMG height=1 alt="" 
                                src="images/pix.gif" width=4 
                                border=0></TD>
              <TD><B><?php echo $pages; ?></B></TD>
              <TD width=42> 
                <?php



		if ($pg!=$pages)



		{



		?>
                <a href="viewstat.php?pg=<?php echo ($pg+1); ?><?php echo "$strpass"; ?>" > 
                <?php



		 }



		?>
                <?php



		if ($pg!=$pages)



		{



		?>
                </a> 
                <?php



		 }



		?>
              </TD>
            </TR>
          </TBODY>
        </TABLE>
        <?php
	}
	?>
      </DIV></TD>
  </tr>
  <tr> 
    <TD> <DIV align=center> 
        <?php
if ($pages>1) 
{
?>
        <?php



		  


if ($pg<=5)
{
$jmpcnt=1;
}
else
{
$jmpcnt=$pg-5;
}

$cnt=0;

while (  $jmpcnt<=$pages   && $cnt<10 )



    {	

$cnt++;

           

	   if ($jmpcnt!=$pg)

	   {

	   ?>
        <a href="viewstat.php?pg=<?php echo "$jmpcnt$strpass"; ?>" > 
        <?php

		}

		else

		{

		echo "<b>";

		}

		echo $jmpcnt;

		if ($jmpcnt!=$pg)

	   {

	   ?>
        </a> 
        <?php

		}

          else

		{

		echo "</b>";

		}





if ($jmpcnt<$pages)



echo " | ";



?>
        <?php



	$jmpcnt = $jmpcnt + 1;



}







		?>
         
        <?php
	}
	?>
        </font></DIV></TD>
  </tr>
  <tr> 
    <td> </td>
  </tr>
</table>

<p>  </p>
<p><br>
<?php
}// end main
include "template1.php";
?>

trq · October 21, 2008

The error is caused by the fact that $rs_query is not a result resource. You should always check your query succeeds before attempting to use any result it might produce.

eaglelegend · October 21, 2008

How do you mean, sorry I dont understand, I didnt code this, someone did this for me, but they are unavalible to help.

MadTechie · October 21, 2008

change

$rs_query=mysql_query($sql);

to

$rs_query=mysql_query($sql) or dir("Error in query:'$sql'<br>".mysql_error());

this should give you more info

eaglelegend · October 23, 2008

$rs_query=mysql_query($sql) or dir("Error in query:'$sql'<br>".mysql_error());

isnt or dir meant to be or die?

dropfaith · October 23, 2008

yes he meant

$rs_query=mysql_query($sql) or die("Error in query:'$sql'<br>".mysql_error());

im pretty sure he meant that at least

eaglelegend · October 23, 2008

LOL I know a bit of PHP at least myself, tbh.

Sign In

whats the error??

Recommended Posts

eaglelegend

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

eaglelegend

Link to comment

Share on other sites

MadTechie

Link to comment

Share on other sites

eaglelegend

Link to comment

Share on other sites

dropfaith

Link to comment

Share on other sites

eaglelegend

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information