Problem with php code

Nixon

Hi I have the fowllowing PHP & mysql code.

<?php

session_start();

include("loginscript.php");

if ($pointcheck=="advert")

{

$getpoints=mysql_query ("select points from outwarinfo where username=\"$sessionusername\" and password=\"$sessionpassword\" ");

while ( $fetchpoints=mysql_fetch_array($getpoints) )

{

echo("".$fetchpoints["points"]);
$getpoints=$fetchpoints["points"];

}

$pointsearned="1";

$pointadd=$getpoints+$pointsearned;

$insertpoints="update outwarinfo set points=\"$pointadd\" where username=\"$sessionusername\" and password=\"$sessionpassword\" ";

$insertpointsnow=mysql_query($insertpoints, $conn);

}

It is relativly simple but at line 18 it says I have a problem. I know I do but I dont know how to solve it any help?

Thanks, Nixon

Nixon

Sorry my problem is on line 19.

tomhath

It would be helpful if you said what the error message said. But my first guess is that you are clobbering the resource that was in variable $getpoints by the assignment to it in the loop.

Nixon

Hi, the error message is:

Warning: Supplied argument is not a valid MySQL result resource in c:\phpdev\www\outwar\points.php on line 13

__________________________________-

The only problem with that is that the script works perfectly with only the echo in and gives me the result that i want.

tomhath

Look carefully at your code.

You execute the query and assign the resulting resource to $getpoints.
You go into a while loop fetching rows from the resource in $getpoints
Inside the loop, you try to make an assignment to $getpoints
Next interation of the while loop no longer has a resource stored in $getpoints. That's line 13. That's the error php reported. Even if there's only one row returned, it will loop around and test for the while loop's exit condition. :mad:

$getpoints = mysql_query (...); 

while ( $fetchpoints=mysql_fetch_array($getpoints) ) { 
  ...
  $getpoints=$fetchpoints["points"]; 
}

Nixon

Ah, i realise i used the same variable twise. Ill go change the variable and hopefully it will sort out my problem, Thanks tomhath.