Jump to content

MySQL Errors HELP PLEASE!

Synitex

By Synitex
in PHP Coding Help

 Share

Recommended Posts

Synitex Newbie

Synitex

Posted
Posted
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]<?php
session_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>
<?php
if(!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>&nbsp;");
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i&nbsp;";
        } else {
            print("<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a>&nbsp;");
    }
}

// Build Next Link
if($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!
Link to comment
Share on other sites
kenrbnsn Regular Member

kenrbnsn

Posted
Posted
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
Link to comment
Share on other sites
Ninjakreborn Prolific Member

Ninjakreborn

Posted
Posted
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.
Link to comment
Share on other sites
GingerRobot Regular Member

GingerRobot

Posted
Posted
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.
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.