select numbers

[unisabilly]

is that possible to select numbers from 1 to number of results, i don't know how to express my question ... let me give an example ~
i want to select the name and surname of the students
i can simply use : "select name,surname from students" and the result will be:

name surname

Mark Robert
Billy Jones
Susan Lee
..... .....
..... ......
..... ...

Michael Geer

but i want the result to be as follow (with using SQL only and there is no 'num' colum in the table, which means SQL must generate it):

num name surname

1 Mark Robert
2 Billy Jones
3 Susan Lee
.... .... ....
.... .... ....
.... .... ....

103 Michael Geer

thanx ~

[bogu]

Add a field in your table: num that is (int), autoincrement, primary key

`user_id` int(11) NOT NULL auto_increment,
PRIMARY KEY  (`user_id`),

Or after u make your selection, you can create your increment:

$sql = "SELECT .... ";
$rez = mysql_query($sql); $inc = 0;
while ($sc = mysql_fetch_assoc($rez))  {
    echo ($i++)."....";
}

Or any other way ...