php 小问题求教

[sinat_35033848]

<?php 

$servername = "qdm121543607.my3w.com";
$username = "qdm121543607";
$password = "a335920";
$dbname = "qdm121543607_db";
extract($_POST);

// 创建链接
$conn = mysql_connect($servername,$username,$password);
mysql_select_db($dbname,$conn);
mysql_query("SET NAMES 'GBK'"); 
// 检查链接
if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
 
//select volum start
$member=$_GET["member"];
$num=$_GET["Num"];
$sql = "Select uname, scores From `#@__member` where uname like '$member'";
$result = mysql_query($sql);


 while($row = mysql_fetch_array($result))
  {
$username=$row['uname'];
$scores=$row['scores'];
$newscores = ($scores - $num);
  }
if ($scores>0)
{
   
	$newscores = ($scores - $num);
	mysqli_query($conn,"UPDATE `dede_member`  SET `scores` = '$newscores' WHERE `uname` ='$member'");
echo $newscores;
}
else
{
 echo $member;
 echo $num;
 echo $scores:
}
mysql_close($conn);
?>

dede内核，写了个php，
想api.php?member=test&num=1
提交member和num
然后如果有则返回scores,并用scores减去num得到newscores 提交到数据库保存在scores
按上面的写的，不知道哪里错了就是没有生效
请高手帮忙看下

[pharaoh_shi]

 while($row = mysql_fetch_array($result))
  {
$username=$row['uname'];
$scores=$row['scores'];
$newscores = ($scores - $num);
  }
// 这里应为
 while($row = mysql_fetch_array($result))
  {
$username[]=$row['uname'];
$scores[]=$row['scores'];
$newscores[] = ($scores - $num);
  }

眼看错误应该是这个，

[xuzuning]

api.php?member=test&num=1 $num=$_GET["Num"]; 必须一致