I'm trying to set up a GPT-site. When I want to test the redeem method, I get the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in (blabla-link, not imporant)/redeem.php on line 39
I've tried some stuff, but nothing seems to be working. Does anybody know what the problem is? All tables and rows exist.
redeem.php code:
<?php include("function.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Inwisselen • <?php echo $siteName; ?></title>
<?php include("headscript.php"); ?>
<?php include("logscr.php"); ?>
</head>
<body>
<div id="wrapper">
<div id="header">
<div class="header_top">
<div class="top">
<div class="logo"> <a href="#"></a> </div>
</div>
<div class="clear"></div>
</div>
<div class="header_bottom">
<?php include("buttons.php"); ?>
<?php include("menu.php"); ?>
</div>
</div>
<div id="body">
<div class="box">
<?php
if(isset($_SESSION["user"])){
if(isset($_GET['id'])){
$rewardId = mysql_real_escape_string($_GET['id']);
$userId = $_SESSION["user"];
$myPoints = mysql_result(mysql_query("SELECT points FROM balances WHERE userId = '$userId'"), 0);
$rewardPoints = mysql_result(mysql_query("SELECT points FROM rewards WHERE rewardId = '$rewardId'"), 0);
if($rewardPoints > $myPoints) {
echo "<h2>Inwisselen mislukt!</h2><p>Geen genoeg punten voor dit item.</p>";
} else {
$reward = mysql_query("SELECT * FROM rewards WHERE rewardId = $rewardId");
echo "<h2>Bevestig koop!</h2>";
echo "<div style=\"padding:10px; border:1px solid #557453; background:url(../images/boxbg.png);\">";
while($row = mysql_fetch_array($reward))
{
echo "<h3>".$row['title']."</h3> <img style=\"margin:5px;\" src=\"". $row['img']."\" width=\"150\" height=\"150\" /><br />" .$row['desc']. "<br><h4 style=\"display:inline\">Huidig aantal punten:</h4> $myPoints <img src=\"images/point.png\" /><br> <h4 style=\"display:inline\">Punten:</h4> ". $row['points']." <img src=\"images/point.png\" /><br> <h4 style=\"display:inline\">Punten over:</h4> ". ($myPoints - $row['points'])." <img src=\"images/point.png\" /><br><br>";
echo "<form id=\"orderForm\" action=\"order.php\" method=\"post\">
<input type=\"hidden\"
name=\"userId\"
value=\"$userId\"
>
<input type=\"hidden\"
name=\"rewardId\"
value=\"$rewardId\"
>
<input type=\"hidden\"
name=\"rewardTitle\"
value=\"".$row['title']."\"
>
";
if($row['type'] == "email"){
echo "<input type=\"hidden\"
name=\"type\"
value=\"email\"
>";
$userEmail = mysql_result(mysql_query("SELECT email FROM users WHERE userId = '$userId'"), 0);
echo "<div class=\"box contactbox\"><h3 style='display:inline;'>Versturen naar...</h3><label><h4>Emailadres:</h4><input name=\"sendto\" value=\"$userEmail\" type=\"text\"></label></div>";
} else if($row['type'] == "ship"){
echo "<input type=\"hidden\"
name=\"type\"
value=\"ship\"
>";
$userEmail = mysql_result(mysql_query("SELECT email FROM users WHERE userId = '$userId'"), 0);
echo "<div class=\"box contactbox\"><h3 style='display:inline;'>Versturen naar...</h3><label><h4>Straat + Huisnummer:</h4><input name=\"street\" value=\"\" type=\"text\"></label><label><h4>Stad:</h4><input name=\"city\" value=\"\" type=\"text\"></label><label><h4>Provincie:</h4><input name=\"state\" value=\"\" type=\"text\"></label><label><h4>Postcode:</h4><input name=\"zip\" value=\"\" type=\"text\"></label></div>";
}
echo "<a href=\"#\" onclick=\"javascript: document.forms['orderForm'].submit();\" ><img border:0px\" src=\"/images/purchase.png\" /></a><br><p>Na de aankoop worden de punten direct van je account afgehaald. Je krijgt een email binnen 24 uur met details. Als het product niet kan worden geleverd, worden je punten teruggestort.</p>";
}
echo "</form></div>";
}
} else {
echo "<h2>Inwisselen mislukt!</h2><p>Je hebt op een ongeldige link geklikt.</p>";
}
} else {
echo "<h2>Inwisselen mislukt!</h2><p>Je moet hiervoor ingelogd zijn.</p>";
}
?>
</div>
</div>
<div id="footer">
<ul>
<?php include("footlinks.php"); ?>
</ul>
</div>
</div>
<?php include("footer.php"); ?>
</body>
</html>