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> </Td></tr> <? if($_SESSION['uname']) { ?> <tr><td colspan="2" align="right">Welcome <?=$_SESSION['uname'];?> </td></tr> <? } ?> <tr><td align="right" colspan="2"><a href="index.php">Home</a> <a href="works.php">How it works</a> <? if($_SESSION['uname']) { ?> <a href="logout.php">Logout </a> <? } else { ?> <a href="login.php">Login </a> <? } ?><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 <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 <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> </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"> </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"> </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> </p> <p> </p> </td> </tr> <? include 'footer.php'; ?> </tbody> </table> </td></tr></table> </body> </html> Code (markup):
Please can you supply a bit more details about the script and the code surrounding the above statement.
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!)
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):
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?
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
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:
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
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):
My bad! Sorry! lose the "$" at the start of mysql_db_select! it should be... $db_selected = mysql_select_db("cwebsite"); PHP:
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 .