1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

A little problem - Please Help

Discussion in 'PHP' started by worlddomain, Aug 15, 2007.

  1. #1
    I tried installing a new script and keep getting this error
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

    I did everything the manual instructed but still no luck - any idea whats wrong and how to solve it

    Thanks Heaps :)

    This is the index.php file
    <? 
    session_start();
    ?>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>.:: Review ::.</title>
    </head>
    <link href="images/style.css" rel="stylesheet" type="text/css" />
    <body topmargin="0" bgcolor="cccccc" leftmargin="0">
    <table width="775" border="0" height="100%" cellpadding="0" cellspacing="0" align="center" bgcolor="#ffffff">
    <tr>
      <td colspan="2" valign="top">
      
      <table cellpadding="0" cellspacing="0" width="100%" border="0" bordercolor="#B5B5B5">
      <tr><td bgcolor="AD0010">
      <img src="images/name.jpg"></td>
      <td bgcolor="AD0010" align="right"> <img src="images/top.jpg" width="441" height="84"></td>
      </tr>
      <tr>
      <td colspan="2">
      <p align="center" style="text-align: center">
    <a href="suggest.php" class="link3">
      <img src="images/button1.gif" border="0" width="170" height="39"></a><a href="registration.php" class="link3"><img src="images/button4.gif" border="0" width="170" height="39"></a><a href="reviews.php" class="link3"><img src="images/button3.gif" border="0" width="170" height="39"></a><a href="search.php" class="link3"><img src="images/button2.gif" border="0" width="170" height="39"></a></td>
      </tr>
     <tr><Td>&nbsp;</Td></tr>
     <?
       if($_SESSION['uname'])
       {
       ?>
       <tr><td colspan="2" align="right">Welcome <?=$_SESSION['uname'];?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
       <?
       }
       ?>
       <tr><td align="right" colspan="2"><a href="index.php">Home</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="works.php">How it works</a>&nbsp;&nbsp;&nbsp;&nbsp;
       <?
       if($_SESSION['uname'])
       {
       ?>
       <a href="logout.php">Logout
          </a>&nbsp;&nbsp;&nbsp;&nbsp;
    	  <?
    	  }
    	  else
    	  {
    	  ?>
    <a href="login.php">Login
          </a>&nbsp;&nbsp;&nbsp;&nbsp; <? } ?><a href="contactus.php">Contact Us</a></td></tr> 
      </table>
      
      
      </td>
    </tr>
    <tr>
    
    
      
    <td valign="top">
    
    
    
    <table cellspacing="0" cellpadding="20" border="0" align="center">
      <tbody>
      <tr><td>
       <form action="search.php" method="post">              
    		<table>
    		<tr><td>Search for:</td><td><input type="text" name="search"></td><td>in&nbsp;<select id="sel" name="sel"><option value="1" id="sel">Category</option><option value="2" id="sel">Product</option></select></td><td><input type="submit" name="sea" value="Search"></td></tr>
    		
    		</table></form>	
      </td></tr>
       <?
       include 'db.php';
    	$sq="select * from category";
    	$re=mysql_query($sq);
    	?>
    	<tr><td align="right" valign="top" colspan="2">
    	<table align="right"><tr><td>	To submit a review please select a category below<BR>You must login first</td></tr>
    	<tr><form action="view_categories.php" method="post"><td align="right" valign="top" colspan="2">Select Category&nbsp;&nbsp;<select id="cat" name="cat" onChange="this.form.submit()">
    	<?
    	if(isset($_REQUEST['cat']))
    	{
    	?>
    	<option><?=$_REQUEST['cat'];?></option>
    	<option>-----------</option>
    	<? 
    	}
    	?>
    	<option>Select Category</option>
    	<?
    	while($ne=mysql_fetch_array($re))
    	{
    	?>
    	<option><?=$ne['name'];?></option>
    	<?
    	}
    	?>
    	</select></td></form></tr>
    	</table>
        <tr>
    	<? 
    	$sq="select * from site_manage where id='1'";
    $re=mysql_query($sq);
    $ne=mysql_fetch_array($re);
    $content=$ne['message'];
    $title=$ne['title'];
    	?>
    	
          <td valign="top"><font color="#660000" class="heading"><b>
          <?=$title;?></b></font>
         
                              <p><?=$content;?></p>
                              <p>&nbsp;</p>
        
           
            
            </td>
    		<td valign="top">
    		<table width="150">
    		<tr><td><b>Latest Products</b></td></tr>
    	  <tr><td><?
    		$lat="select * from add_product where approve='1' order by pid DESC limit 0,5";
    		$lats=mysql_query($lat);
    		while($latss=mysql_fetch_array($lats))
    		{
    		?>
    		<a href="view_products.php?action=product&prid=<?=$latss['pid'];?>"><?=$latss['pname']."<br><br>";?></a>
    		<? 
    		}
    		?></td></tr>
    		</table>
    		</td>
    		
    		</tr>
    <?
    
    /*
    $sql="select sum(rating) as rate,sum(person) as per,prid as pid from comment group by prid";
    $res=mysql_query($sql);
    
    while($new=mysql_fetch_array($res))
    {
    echo $new['pid']."PID"."<br><br>";
    $aa=$new['rate'];
    echo $aa."RATE"."<br><br>";
    $bb=$new['per'];
    echo $bb."PERSON"."<br><br>";
    $cc=($aa/$bb);
    
    $dd=round($cc);
    echo $dd."TOTAL"."<br><br>";
    if($dd==8)
    {
    $sq="select * from comment group by prid having round((sum(rating)/sum(person))) <= 10";
    $re=mysql_query($sq);
    while($ne=mysql_fetch_array($re))
    {
    echo $ne['coment'];
    }
    
    }}
    */
    
    ?>
    <tr>
    		<td valign="top">
    		<table align="center">
    		<tr><td>
    		<font color="#660000" class="heading"><b>
          Top Rated Products</b></font>
       </td></tr>
    			  </table>
    			  <tr><td valign="top">
    			
    		<? 
    /*$zz="select sum(rating) as rats from comment group by prid";
    $xx=mysql_query($zz);
    while($y=mysql_fetch_array($xx))
    {
    echo $y['rats'];	
    $o=$y['rats'];
    $oo="select max($o) as m from comment where sum(rating)=$o";
    $xx=mysql_query($zz);
    $y=mysql_fetch_array($xx);
    }
    $sqs="select round(sum(rating)/sum(person),1) as r from comment group by prid";
    $ress=mysql_query($sqs);
    $news=mysql_fetch_array($ress);
    $r=$news['r'];*/
    $sql1="select round(sum(rating)/sum(person),1) as rat,name as nam,prid as prid from comment  group by prid order by rat DESC  limit 0,5";
    $res1=mysql_query($sql1);
    
    ?>
    
    <table align="center">
    <tr><td valign="top"><b>Product Name</b></td><td colspan="2">&nbsp</td><td valign="top"><b>Average Rating</b></td></tr>
    <? 
    while($new1=mysql_fetch_array($res1))
    {
    
    //echo $new1['rat'];
    $b=$new1['rat'];
    $dd=$new1['rat'];
    $a=$new1['prid'];
    $sql="select max($b) as ra,prid as prid,name as name from comment  group by prid  having round(sum(rating)/sum(person),1)='$b'";
    $res=mysql_query($sql);
    $new=mysql_fetch_array($res);
    //echo $new['ra'];
    
    ?>
    <tr><Td><a href="view_products.php?action=product&prid=<?=$new['prid'];?>"><?=$new['name'];?></a></Td>
    <td colspan="2">&nbsp;</td><td><? 
    	   if($dd==0)
    	 {
    	 ?>
    <b>Not Rated</b>	 
    <? 
    }
    elseif(($dd>0)&&($dd<=0.5))
    {
     ?>
    	 <img src="images/star3.jpg" border="0"><img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0">
    <? 
    
    }
    elseif(($dd>0.6) && ($dd<=1))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif(($dd>1.1)&&($dd<=1.5))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star3.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0">
    <? 
    
    }
    elseif(($dd>1.6)&&($dd<=2))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif((($dd>2.1) && ($dd<=2.5)))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star3.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif(($dd>2.6)&&($dd<=3))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star2.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif(($dd>3.1)&&($dd<=3.5))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star3.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif(($dd>3.6)&&($dd<=4))
    {
     ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star2.jpg" border="0"> 
    <? 
    
    }
    elseif(($dd>4.1)&&($dd<=4.5))
    { ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star3.jpg" border="0"> 
    
     <?
    }
    elseif(($dd>4.6)&&($dd<=5))
    { ?>
    	 <img src="images/star1.jpg" border="0"><img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> <img src="images/star1.jpg" border="0"> 
    
     <?
    }
    ?>
    </td></tr>
    
    <? 
    }
    
    
    
    		?>  
    		</table>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
           </td>
        </tr>
    	
    	<?
    	include 'footer.php';
    	?>
    	
      </tbody>
    </table>
    
    </td></tr></table>
    
    </body>
    </html>
    
    Code (markup):
     
    worlddomain, Aug 15, 2007 IP
    killerj likes this.
  2. adamjblakey

    adamjblakey Active Member

    Messages:
    1,121
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    80
    #2
    Please can you supply a bit more details about the script and the code surrounding the above statement.
     
    adamjblakey, Aug 15, 2007 IP
  3. adamjblakey

    adamjblakey Active Member

    Messages:
    1,121
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    80
    #3
    What exactly are you submitting to get that error? Which Form?
     
    adamjblakey, Aug 15, 2007 IP
  4. worlddomain

    worlddomain Well-Known Member

    Messages:
    1,138
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #4
    when I open the home page that is the error I get all over the page
     
    worlddomain, Aug 15, 2007 IP
  5. ecentricNick

    ecentricNick Peon

    Messages:
    351
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The script, as you have it pasted, does not contain a connect command. It's not connecting to the database, therefore, the result sets will all be invalid.

    The only part that might do it is "db.php" which is included on line 72. So can you paste what is in db.php?

    (do remove any usernames/passwords though!)
     
    ecentricNick, Aug 15, 2007 IP
  6. worlddomain

    worlddomain Well-Known Member

    Messages:
    1,138
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #6
    This is my db.php file
    The details are not my personal user and pw....
    Thanks for helping out
    <?
    
    $conn=mysql_connect("localhost","arrinsol_review","review");
    
    mysql_select_db("arrinsol_review");
    
    $query="select * from register";
    
    $ins="insert into regiser";
    
    ?>
    
    Code (markup):
     
    worlddomain, Aug 15, 2007 IP
  7. ecentricNick

    ecentricNick Peon

    Messages:
    351
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Can you add...

    
    if (!$conn) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    
    PHP:
    ...immediately after the connect statement in db.php and try it again?
     
    ecentricNick, Aug 15, 2007 IP
  8. worlddomain

    worlddomain Well-Known Member

    Messages:
    1,138
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #8
    tried that...now I get this error - pretty much similar to the last

    Connected successfully
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/usr/public_html/site/index.php on line 103
     
    worlddomain, Aug 15, 2007 IP
  9. ecentricNick

    ecentricNick Peon

    Messages:
    351
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Ok, but at least we've proved you're connecting.

    Now to prove if the database selection works...

    Change...


    
    mysql_select_db("arrinsol_review");
    
    PHP:
    to....

    
    $db_selected = $mysql_select_db("arrinsol_review");
    if (!$db_selected) {
        die ('Can\'t use db : ' . mysql_error());
    }
    
    PHP:
     
    ecentricNick, Aug 15, 2007 IP
  10. worlddomain

    worlddomain Well-Known Member

    Messages:
    1,138
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #10
    done - Now I get this error

    Connected successfully
    Fatal error: Call to undefined function: () in /home/usr/public_html/site/db.php on line 9
     
    worlddomain, Aug 15, 2007 IP
  11. ecentricNick

    ecentricNick Peon

    Messages:
    351
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Sounds like a typo in what you've just inserted - double check it? Or paste your current db.php code
     
    ecentricNick, Aug 15, 2007 IP
  12. worlddomain

    worlddomain Well-Known Member

    Messages:
    1,138
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #12
    I could have messed up...not sure

    <?
    
    $conn=mysql_connect("localhost","cwebsite","pw");
    if (!$conn) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    
    $db_selected = $mysql_select_db("cwebsite");
    if (!$db_selected) {
        die ('Can\'t use db : ' . mysql_error());
    }
    
    $query="select * from register";
    
    $ins="insert into regiser";
    
    ?>
    Code (markup):
     
    worlddomain, Aug 15, 2007 IP
  13. ecentricNick

    ecentricNick Peon

    Messages:
    351
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #13
    My bad! Sorry!

    lose the "$" at the start of mysql_db_select!

    it should be...
    
    $db_selected = mysql_select_db("cwebsite");
    
    PHP:
     
    ecentricNick, Aug 15, 2007 IP
  14. killerj

    killerj Active Member

    Messages:
    765
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    95
    #14
    Ok , I'll help you out . Please PM me the details and your contact info.
    Edit : Work Completed . Nice guy to work for . adding reps to you . :)
     
    killerj, Aug 15, 2007 IP
    worlddomain likes this.