dump query result to another table

[trigger8]

How do I insert the result (colume1) from this query to another table?

SELECT colume1 FROM table1 ORDER BY count DESC

[cupid]

With or without the use of PHP? Has the other table already been created with the appropriate field specifications?

[trigger8]

Let's assumed that another table is already there named table2, and the column named column2.

[cupid]

I suppose this could be a solution. Haven't tested it, but it should work.

$query = mysql_query("select column1 from table1");
while ($result = mysql_fetch_object($query)) {

  mysql_query("insert into table2 (column2) values ('".$result->column1."')");

}