write from php.

[grlayouts]

ok if i have the code
Code:

include("config.php");
$result =  mysql_query("select * from players WHERE id > 1 order by level desc limit 10");
$result1 =  mysql_query("select * from players");


how would i get those 10 records to write into another table in my database called results?

eg, round1, name, id, rank, score

[paul2463]

[code]
<?php
$result =  mysql_query("select * from players WHERE id > 1 order by level desc limit 10");
while($row = mysql_fetch_assoc($result))
{
  $var1 = $row['column1'];
  $var2 = $row['column2'];
  $var3 = $row['column3'];
  $query = "INSERT INTO results(column1, column2, column3) VALUES('$var1', '$var2', $var3')";
  $res = myslq_query($query) or die ("Insert Failed".  mysql_error()); 
}
?>
[/code]