Mysql Query

[Zeeshan]

Hi everybody,

How can I get rownum using MySQL queries ,
In Oracle one can you in this way SELECT rownum as srno, fname FROM
tablename
suppose If there are 45 records and if i use while for the

srno should display 1, 2, 3, ... 45

query like SELECT rownum as srno, fname FROM tablename

I dont want to use php counter, i want it from query

Reagrds
Friend

[Berimor]

On Wed, 02 Nov 2005 12:50:10 +0200, Zeeshan <ze********@gmail.com> wrote:

Hi everybody,

How can I get rownum using MySQL queries ,
In Oracle one can you in this way SELECT rownum as srno, fname FROM
$sql=mysql_querry(SELECT COUNT(*) FROM table_name WHERE condition);
$res=mysql_fetch_row($sql);
$numofrows=$res[0];

tablename
suppose If there are 45 records and if i use while for the

srno should display 1, 2, 3, ... 45

query like SELECT rownum as srno, fname FROM tablename

I dont want to use php counter, i want it from query

Reagrds
Friend

--
---
Exact Meta Search | Major Search Engine
http://exactsearcher.com

[Berimor]

On Wed, 02 Nov 2005 14:23:51 +0200, Berimor <ro***@roman.roman> wrote:

On Wed, 02 Nov 2005 12:50:10 +0200, Zeeshan <ze********@gmail.com> wrote:

Hi everybody,

How can I get rownum using MySQL queries ,
In Oracle one can you in this way SELECT rownum as srno, fname FROM
$sql=mysql_querry(SELECT COUNT(*) FROM table_name WHERE condition);

sorry $sql=mysql_query("SELECT COUNT(*) FROM table_name WHERE
condition"); :)
$res=mysql_fetch_row($sql);
$numofrows=$res[0];

tablename
suppose If there are 45 records and if i use while for the

srno should display 1, 2, 3, ... 45

query like SELECT rownum as srno, fname FROM tablename

I dont want to use php counter, i want it from query

Reagrds
Friend

--
---
Exact Meta Search | Major Search Engine
http://exactsearcher.com

[Ewoud Dronkert]

Zeeshan wrote:

Hi everybody,

Better asked in comp.databases.mysql

--
E. Dronkert