Transcations Between Tables

[nichemtktg]

Can this be done with just sql? If so how?

<?php
require_once "connect_to_mysql.php";
$result = mysql_query("SELECT * FROM preplan") or die(mysql_error());
while ($result2 = mysql_fetch_array($result)) {
  $curwipprice = $result2['curwipprice'];
  $cliorder = $result2['cliorder'];
  require_once "connect_to_mysql.php";
  mysql_query("UPDATE plan SET curwipprice = '" . $curwipprice . "' WHERE cliorder = '" . $cliorder . "'") or die(mysql_error());
}
?>

[r937]

@nichemtktg

Can this be done with just sql?

yes

UPDATE preplan 
INNER
  JOIN plan
    ON plan.cliorder = preplan.cliorder
   SET plan.curwipprice = preplan.curwipprice

[nichemtktg]

Thanks r937!