Shortening This COde

[iceraider]

I just need to know how I can shorten some parts of this, and speed it up.

  // Get all there payout information
  $result = mysql_query("SELECT id,user,l1,l2,l3,r1,r2,r3 FROM payouts WHERE id='$id'");
  $a = mysql_fetch_row($result);
  $pit = $a[0];
  $user = $a[1]; 
  $l1 = $a[2];
  $l2 = $a[3];
  $l3 = $a[4];
  $r1 = $a[5];
  $r2 = $a[6];
  $r3 = $a[7];

  // Get all there user information
  $result = mysql_query("SELECT l1,l2,l3,r1,r2,r3 FROM members WHERE id='$user'");
  $mem = mysql_fetch_row($result);

  $a = $mem[0] - $l1;
  $b = $mem[1] - $l2;
  $c = $mem[2] - $l3;

  // Split up all that crap cause its all in |'s
  $d = split("\|", $r1);
  $re1 = $d[0];
  $re2 = $d[1];
  $re3 = $d[2];

  $e = split("\|", $r2);
  $ref1 = $e[0];
  $ref2 = $e[1];
  $ref3 = $e[2];

  $f = split("\|", $r3);
  $refe1 = $f[0];
  $refe2 = $f[1];
  $refe3 = $f[2];

  $g = split("\|", $mem[3]);
  $sre1 = $g[0];
  $sre2 = $g[1];
  $sre3 = $g[2];

  $h = split("\|", $mem[4]);
  $sref1 = $h[0];
  $sref2 = $h[1];
  $sref3 = $h[2];

  $i = split("\|", $mem[5]);
  $srefe1 = $i[0];
  $srefe2 = $i[1];
  $srefe3 = $i[2];

  // Minus these two from each other
  $d = $sre1 - $re1;
  $e = $sre2 - $re2;
  $f = $sre3 - $re3;
  $g = "$d|$e|$f";
  $h = $sref1 - $ref1;
  $i = $sref2 - $ref2;
  $k = $sref3 - $ref3;
  $l = "$h|$i|$k";
  $m = $srefe1 - $refe1;
  $n = $srefe2 - $refe2;
  $o = $srefe3 - $refe3;
  $p = "$m|$n|$o";

  echo "$HDR This member has just been updated! $FTR";

  // Update them back after they've been minused by each other
  mysql_query("UPDATE members SET l1='$a', l2='$b', l3='$c', r1='$g', r2='$l', r3='$p' WHERE id='$user'");
  mysql_query("UPDATE payouts SET status='done' WHERE id='$pit'");

[planetsim]

Instead of the $var = $r["feildname"];
Why not take that bit out and just use the $r["feldname"];
That should cut 5-8lines

[Weedpacket]

What planetsim said (it's the most straightforward and self-documenting, and the one I use); an alternative would be to fetch rows or split[*] arrays directly into the intended variables by using list().

*Except I'd use explode() - faster and more appropriate - and no need to escape the | character

[tomhath]

A big part of the slowness is because you have two selects, you should be joining the two tables together in a single query. Probably need indexes on the id column in both tables.