mysql writing.

[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");
[/code]

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

eg, round1, name, id, rank, score

[cicibo]

just used this code

NSERT INTO result
  SELECT round1,name,id,rank,score
  FROM players WHERE id > 1 order by level desc limit 10

[grlayouts]

that doesnt work.

[Andy Booth]

I think he meant...

INSERT...
not
NSERT...

see if that works :)

[grlayouts]

dude.. i guessed that.

[wildteen88]

I believe you've got to list your column names for the data to go into for the results table. So try this:
[code]INSERT INTO results (round1, name, rank, score)
  SELECT p.round1, p.name, p.rank, p.score
  FROM players AS p WHERE p.id > 1 ORDER BY p.level DESC LIMIT 10[/code]