SELECT 값에 자동으로 순번 매기기

SQL :
SET @NUM := 0;
SELECT @NUM := @NUM + 1 AS SEQ, field FROM table

-> 결과
SEQ FIELD
1 field
2 field
3 field

PHP예제 :

<?php
mysql_query("SET @NUM := 0");
$result = mysql_query("SELECT @NUM := @NUM + 1 AS SEQ, field FROM table");
while($row=mysql_fetch_row($result)) {
  print_r($row);
}
?>