Php mysql insert problem

Hi
I have a table with 90 rows each row has a number between 1-90, i select the 90 numbers using ORDER BY RAND() i want to be able to post the 90 random numbers into a temp table how would i do the insert query,

its only posting 1 number

this is the code i have so far

 $result = mysql_query("SELECT * FROM randnumber ORDER BY RAND() ");

while($row = mysql_fetch_array($result))
  {
  echo $row['num'] ;
  echo "<br />";
  }
  $num = $_POST['num'];
$sql = mysql_query("INSERT INTO tempnum (num,called) 
     VALUES('num',1)")  
     or die (mysql_error()); 

hi
i have moved the query inside the loop its posting 90 entries

but no data just a blank space

here is the code now

 $result = mysql_query("SELECT * FROM randnumber ORDER BY RAND() ");


    
while($row = mysql_fetch_array($result))
  {
	$num = $_POST['num'];  
	  $sql = mysql_query("INSERT INTO tempnum (num,called) 
     VALUES('$num',1)")   or die (mysql_error()); 
  echo $row['num'] ;
  echo "<br />";
  }

thankyou

If I read it right you have the insert query statement outside the while loop, would need to be inside the while loop if you want all 90 records going into the temp table.