What's wrong with this code?

[Kalin Somphane]

   if($member['refname'] != "") {
      $request2 = mysql_query("INSERT INTO {$db_prefix}referrers (et_referrer,et_referred,date) VALUES('$member[refname]','$member[user]','$requesttime')");
      $request3 = mysql_query("SELECT referred FROM {$db_prefix}members WHERE memberName='$member[refname]'");
      $referredcount = $request3["referred"];
      $asdf = $referredcount;
      $cheares="it works";
      $cheares2 = $member["refname"];
      $referredcount++;
      $request = mysql_query("UPDATE {$db_prefix}members SET referred='$referredcount' WHERE memberName='$member[refname]'");
   }

[Zef Hemel]

What error do you get? What is the code supposed to do?

Just some questions popped up in my mind

[Joseph Fung]

one error is this
$request3 = mysql_query("SELECT referred FROM {$db_prefix}members WHERE memberName='$member[refname]'");
      $referredcount = $request3["referred"];

change it to

$request3 = mysql_query("SELECT referred FROM {$db_prefix}members WHERE memberName='$member[refname]'");
$row = mysql_fetch_array($request3);
      $referredcount = $row["referred"];

[Joseph Fung]

and, in the interest of saving resources, you could use $request for all of the queries as opposed to $request, $request2 and $request3

[Kalin Somphane]

Wow that was soooo quick.

But it seems that this sql query is not working. And this is in the register.php file. I am wondering if I should just do the full protocol to get to the table.

$request2 = mysql_query("INSERT INTO {$db_prefix}referrers (et_referrer,et_referred,date) VALUES('$member[refname]','$member[user]','$requesttime')");