Synitex Posted July 12, 2006 Share Posted July 12, 2006 Hey, im writing a gallery/comments etc script, and i keep getting this error :Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 33 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 41 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 49 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 57 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 65 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prodream/public_html/prom/gallery.php on line 73 Heres the code:[code]<?phpsession_start();$conn = mysql_connect("localhost","####","####");$db = mysql_select_db("####");?><html><head><title>Habbo Alterations - Habbo's No.1 Gallery.</title><STYLE TYPE="text/css">A:link {text-decoration:none; color:#334016;}A:visited {text-decoration:none; color:#334016;}A:hover {text-decoration:none; color:#A3B975;}</style></head><body bgcolor=#A3B975><table cellspacing=0 cellpadding=0 align=center width=100%><tr><td><?php include("nav.php"); ?></TD></tr></table><font color=3D4E17 face=verdana size=1><?phpif(!isset($page)){$page = 1;}$maxresults = 36;$rowresults = 6;$from = (($page * $maxresults) - $maxresults);$sql = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");print("<br><table cellpadding=1 bgcolor=819556 style='border-width: 1px; border-style: ridge; border-color: #3D4E17' width=100% align=center>");print("<tr>");print("<td colspan=5><center><font color=3D4E17 face=verdana size=1><strong>Click on an image to comment on it.</TD></TR><TR>");while($rows=mysql_fetch_array($sql)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows[id]><img border=0width='100' height='100' src=gallerythumbs/$rows[image]></a><br><strong>$rows[name]</strong><br><u><a href=viewpic.php?id=$rows[id]>$rows[title]</A></u><br>$rows[comment]</TD>");}print("</tr>");print("<tr>");$from = $from + 5;$sql2 = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");while($rows2=mysql_fetch_array($sql2)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows2[id]><img border=0width='100' height='100' src=gallerythumbs/$rows2[image]></a><br><strong>$rows2[name]</strong><br><u><a href=viewpic.php?id=$rows2[id]>$rows2[title]</a></u><br>$rows2[comment]</TD>");}print("</tr>");print("<tr>");$from = $from +5;$sql3 = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");while($rows3=mysql_fetch_array($sql3)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows3[id]><img border=0width='100' height='100' src=gallerythumbs/$rows3[image]></a><br><strong>$rows3[name]</strong><br><u><a href=viewpic.php?id=$rows3[id]>$rows3[title]</a></u><br>$rows3[comment]</TD>");}print("</tr>");print("<tr>");$from = $from + 5;$sql4 = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");while($rows4=mysql_fetch_array($sql4)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows4[id]><img border=0width='100' height='100' src=gallerythumbs/$rows4[image]></A><br><strong>$rows4[name]</strong><br><u><a href=viewpic.php?id=$rows4[id]>$rows4[title]</a></u><br>$rows4[comment]</TD>");}print("</tr>");print("<tr>");$from = $from + 5;$sql2 = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");while($rows2=mysql_fetch_array($sql2)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows2[id]><img border=0width='100' height='100' src=gallerythumbs/$rows2[image]></a><br><strong>$rows2[name]</strong><br><u><a href=viewpic.php?id=$rows2[id]>$rows2[title]</a></u><br>$rows2[comment]</TD>");}print("</tr>");print("<tr>");$from = $from + 5;$sql2 = MYSQL_QUERY("SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults");while($rows2=mysql_fetch_array($sql2)){print("<TD width=20% align=center><center><font color=3D4E17 face=verdana size=1><a href=viewpic.php?id=$rows2[id]><img border=0width='100' height='100' src=gallerythumbs/$rows2[image]></a><br><strong>$rows2[name]</strong><br><u><a href=viewpic.php?id=$rows2[id]>$rows2[title]</a></u><br>$rows2[comment]</TD>");}print("</tr>");print("<TR><TD colspan=5 align=center><font color=3D4E17 face=verdana size=1><strong>Select a page<BR>");$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM images WHERE active='1'"),0);$total_pages = ceil($total_results / $maxresults);if($page > 1){ $prev = ($page - 1); print("<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><< Previous</a> ");}for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { print("<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "); }}// Build Next Linkif($page < $total_pages){ $next = ($page + 1); print("<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next >></a>");}print("</TD></TR>");?></table></body></html> [/code]Can someone help me?Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/ Share on other sites More sharing options...
kenrbnsn Posted July 12, 2006 Share Posted July 12, 2006 An error like that means that your previous mysql_query did not work correctly.Change your mysql_query() calls to be similar to this:[code]<?php$q = "SELECT id, image, comment, title, name FROM images WHERE active='1' ORDER BY date DESC LIMIT $from, $rowresults";$sql = MYSQL_QUERY($q) or die("Problem with the query: $q<br>" . mysql_error());?>[/code]Also, please edit your post to change the [nobbc][quote][/nobbc] tag to a [nobbc][code][/nobbc] tag and the [nobbc][/quote][/nobbc] tag to a [nobbc][/code][/nobbc] tag.Ken Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56966 Share on other sites More sharing options...
Ninjakreborn Posted July 12, 2006 Share Posted July 12, 2006 What the hell dude, you shouldn't put your username and password down like that, XXXX or #### them out, no matter what you do now, chances are someone is going to get into your db, unless you made up a random username and password for that, that is something you will probably regret. Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56967 Share on other sites More sharing options...
Synitex Posted July 12, 2006 Author Share Posted July 12, 2006 Okay.. done what you said.. i now get this www.prodreaming.co.uk/prom/gallery.phpI dont know what to do.Help please. Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56978 Share on other sites More sharing options...
GingerRobot Posted July 12, 2006 Share Posted July 12, 2006 Are you sure you've selected the right table? It says the table "images" doesn't exist. Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56981 Share on other sites More sharing options...
Synitex Posted July 12, 2006 Author Share Posted July 12, 2006 Ahh Im kinda retarded at this lol.. Could you do it for me? im still learning PHP :( Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56990 Share on other sites More sharing options...
GingerRobot Posted July 12, 2006 Share Posted July 12, 2006 Its not something i can do for you.Did you create the database with the table in? If so how did you create it, did you use phpMyAdmin? Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-56993 Share on other sites More sharing options...
Synitex Posted July 12, 2006 Author Share Posted July 12, 2006 Actually, the script was sent to me, so i have no idea what the tables are.. the tables i have found that need creating so far are images and users thats the names of the tables.. Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-57007 Share on other sites More sharing options...
GingerRobot Posted July 13, 2006 Share Posted July 13, 2006 Well you will have to create the tables to be able to use the script, do you have access to phpMyAdmin? Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-57160 Share on other sites More sharing options...
brown2005 Posted July 13, 2006 Share Posted July 13, 2006 ask the person that sent u it, to send the table info to create the tables Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-57162 Share on other sites More sharing options...
Synitex Posted July 13, 2006 Author Share Posted July 13, 2006 Yeah i got access to PHPMyAdmin Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-57163 Share on other sites More sharing options...
GingerRobot Posted July 13, 2006 Share Posted July 13, 2006 Do you know how to use it? You will need to log into it and create the tables. You may well have problems for a while though because you do not know all the fields and types the script requires. Brown2005 is right, your best bet would be to contact the person who gave you the script. Quote Link to comment https://forums.phpfreaks.com/topic/14415-mysql-errors-help-please/#findComment-57184 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.