Debug simple short script

Nixon

Hey guys & gals,

I have a script which is meant to transfer a variable from onepage to another but it doesn't. I have never tried this before so it could be all wrong. Please have a look.

index.php -


<?php

include("connectdb.inc.php"); 

$querytop= mysql_query( "select outwarusername, outwarlink, points, clicks from outwarinfo order by points desc limit 5" );

while ( $row=mysql_fetch_array($querytop)  )
{
$outwarname=$row["outwarusername"];
$outwarlink=$row["outwarlink"];
$outwarpoints=$row["points"];
$outwarclicks=$row["clicks"];

print 	"<table><tr><td width=150>$outwarname</td><td width=300><a href=\"deductpoint.php?UserId=
		$outwarname\" target=\"_blank\">$outwarlink</a></td><td width=100>$outwarpoints</td><td width=\"100\">
		$outwarclicks</td></tr></table>";

}

?>

deductpoint.php


<?php

include ("connectdb.inc.php");

$userid=$_POST['UserId'];

$queryusername=mysql_query( "select points from outwarinfo where outwarusername=\"$userid\" " ) or die ("Sorry could not select user");

$getusernamearray=mysql_fetch_array($queryusername) or die("Sorry could not fetch array");

$pointsuser=$getusernamearray[points];

$pointdeduct=1;

$newpointamount=$pointsuser - $pointdeduct;

mysql_query("update outwarinfo set points=$newpointamount where outwarusername=\"$userid\" ");

?>

My problme on this page is a problem witht he fatch_array. Is this because the value is empty? Thanks. Nixon.

leatherback

Hi,

Looks to me that this should work:

$queryusername=mysql_query( "select points from outwarinfo where outwarusername=$userid" ) or die ("Sorry could not select user");

You use the "" for textvalues. But you have a variable, so you don't need them. You use the \" only if you try to get a "in a variable, and you want PhP to read the double quotes, instead of ïnterpreting"them.

PS:
You could just use directly:

$row[outwarusername],
you don't need to create var's first.

PPS: You don't need quotes in $row["outwarusername"];.