Row Numbers

Applications Report PDF
#1

How can I display row numbers in a subselect area?

In hope to get any solution,

Hans

#2

Re: Row Numbers

Hi!
Maybe you could try something like suggested here :

http://forums.mysql.com/read.php?10,36490,36511

http://forums.mysql.com/read.php?10,36490,235793#msg-235793

Hope it helps.

#3

Re: Row Numbers

Thanks Ishvor,

but this is not the solution that I want. It must be like the row numbers that you can display in grids.

In hope to get any help.

Hans.

#4

Re: Row Numbers

Perhaps you can just create a row in your SQL?


SELECT @i:=@i+1 AS myrow, users.*
FROM users,(SELECT @i:=0) r

Regards,
Scott.

#5

Re: Row Numbers

Problem fixed,

Thank you ScottMartin

Best regards,

Hans