heb helaas weer een fout waar ik niet uit kom maar heb wel gelukkig gezien dat bijna alle foutjes het zelfde aan geven :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /storage/mijndomein/users/068256/public/sites/gpt.play4ever.nl/member.php on line 88

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /storage/mijndomein/users/068256/public/sites/gpt.play4ever.nl/member.php on line 91

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/mijndomein/users/068256/public/sites/gpt.play4ever.nl/member.php on line 94




mijn php script:

<? session_start(); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">;
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en">

<head>
<title><? include "config.php"; echo "$Site_Name"; ?> - Get paid to complete offers!</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />

<!-- **** layout stylesheet **** -->
<link rel="stylesheet" type="text/css" href="style/style.css" />

<!-- **** colour scheme stylesheet **** -->
<link rel="stylesheet" type="text/css" href="style/green.css" />

</head>

<body>
<div id="main">
<div id="links">
<!-- **** LINKS **** -->

</div>
<div id="menu">
<ul>

<li><a href="index.php">home</a></li>
<li><a href="login.php">login</a></li>
<li><a href="register.php">register</a></li>
<li><a id="selected" href="member.php">member area</a></li>
<li><a href="mailto:<? include "config.php"; echo "$Owner_Email"; ?>">contact</a></li>
</ul>
</div>
<?
include "config.php";
?>
<div id="logo"><h1><? echo "$Site_Name"; ?></h1><h2><? echo "$Slogan"; ?></h2></div> <div id="content">
<div id="column1">
<div class="sidebaritem">
<div class="sbihead">
<h1>latest news</h1>
</div>
<div class="sbicontent">
<!-- **** INSERT NEWS ITEMS HERE **** -->
<? include "news.php"; ?>
</div>
</div>
<div class="sidebaritem">
<div class="sbihead">
<h1>Statistics</h1>
</div>
<div class="sbilinks">
<!-- **** INSERT ADDITIONAL LINKS HERE **** -->
<ul>
<? include "stat.php"; ?> </ul>
</div>
</div>
<div class="sidebaritem">
<div class="sbihead">
<h1>testimonials</h1>
</div>
<div class="sbicontent">

<p>
<? include "testi.php"; ?>
</p>
</div>
</div>
</div>
<div id="column2">
<h1>member area</h1>
<p>
<?

require('main.php');


if (!isset($_SESSION['uid'])) {
$_SESSION['uid'] = $_REQUEST['uid'];
$_SESSION['pwd'] = $_REQUEST['pwd'];
}

$uid = $_SESSION['uid'];
$pwd = $_SESSION['pwd'];

db_connect();

$res = mysql_query("SELECT * FROM users WHERE uid='$uid' AND pwd='$pwd' and status='active'");
$re = mysql_fetch_array($res);

$bal = mysql_query("SELECT balance FROM users WHERE uid='$uid' AND pwd='$pwd' and status='active'");
$bala = mysql_fetch_array($bal);


if(mysql_num_rows($res) != 0) {

include(INC_DIR."header.php");

echo "<br><b><center>

<a href='member.php' border='0'><img src='home.png' border='0'></img></a>

<a href='offers.php' border='0'><img src='offers.png' border='0'></img></a>

<a href='pending.php' border='0'><img src='pending.png' border='0'></img></a>

<a href='completed.php' border='0'><img src='completed.png' border='0'></img></a><br>";
echo "&nbsp;<br> <center>Account Balance: <b>";

$con = mysql_connect("mijndb","mijnnaam","mijnWW");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("mijnnaam", $con);$result = mysql_query("SELECT * FROM users WHERE uid='$uid'");while($row = mysql_fetch_array($result))
{

echo "$";
echo $row['balance'];

echo "<br> Paypal address: ";
echo $row['pp'];
echo "<br>&nbsp;<br>";
echo "<center>Message from admin:<br><table border='2' bordercolor='#F90D0D' width='500' bgcolor='white'>
<tr>
<td>";
echo $row['msg'];
echo "</td>
</tr>
</table><br>";
echo "&nbsp;<br></center>";

$amo = $row['balance'];

if ($amo > 4.99) {
echo "<a href='requestedpayment.php' border='0'><img src='request.JPG' border='0'></img></a><br>&nbsp;<br>";
} elseif ($a == $b) {
echo "Get atleast $5.00 in your account to instantly request a payment to be sent within 48 hours!<br>";
} else {
echo "Get atleast $5.00 in your account to instantly request a payment to be sent within 48 hours!<br>";
}




echo "Welcome to the member area, <b>$uid</b>!<br>
&nbsp;<br>
<hr><br>
To view the offers you can complete, click the &quot;Offers&quot; button for a full list, it will show you all the details you need to know about each offer.<br> &nbsp;<br>
<i>BEFORE COMPLETING AN OFFER,</i> click the ID ( the way left of the offer on the <a href='offers.php'>offers</a> list, to view the information about it, <i> AND WHAT IS NEEDED FOR YOU TO RECEIVE CREDIT.</i><br> &nbsp;<br>After you know what needs to be completed, click the TITLE OF THE OFFER to complete it, once completed, on the offer list page click the DONE button on the way right to mark it as PENDING.<br><hr>";

}mysql_close($con);


echo "<br></b></center>";
echo "&nbsp;<br>
<center><a href='logout.php' border='0'><img src='logout.png' border='0'></img></a></center>
</p>";

} else {

include(INC_DIR."header.php");
unset($_SESSION['uid']);
unset($_SESSION['pwd']);

echo "<br><b>Login Failed</b> Try Again!";
include(INC_DIR."login.php");

}


include(INC_DIR."footer.php");
db_disconnect();




?>


</div>
</div>




<div id="footer">
copyright &copy; 2007 <? echo "$Site_Name"; ?>
</div>
</body>
</html>

als jullie een oplossing hebben hier voor hoor ik dat graag.
maar dat lees ik morgen wel.
al vast bedankt
Uhm. met alle respect, maar je verwacht toch niet dat we dit helemaal gaan doornemen? Er staat regel 88 en 91.. waar moet ik dat vinden op deze manier? Je kunt je script wel posten en verwachten dat we het oplossen maar geef wel code an ons dat er toedoet..

echter als ik het zo zie is je probleem !isset($_SESSION

die ! moet weg en je maakt ook geen verbinding met een database. Dus worden die queries niet uitgevoerd en kun je ook geen variabelen opslaan in en uitlezen in je array. En wat is de status= active? Dat wordt ook nergens in je code teruggevonden.. als je niet aan de voorwaarden voldoet wordt er ook geen array in je vars geplaatst..

Maar in vervolg: post relevante code.. want hier schieten we niets mee op.....
sorry, was gister avond/nacht snel an het opletten en dacht eigelijk zo snel mogelijk vragen, maar zal daar voor taan aan denken, en zou de volgende info wat je hebt gezonden even goed doornemen en kijken of ikhet voor mekaar krijg.

Reageren