copy_prices.php

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT price, product_id FROM product_attributes");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  echo "price: ".$row[0]
  echo "product_id".$row[1]
}

mysql_free_result($result); // clean memory
?>