|
|
Posted by Berimor on 11/02/05 14:23
On Wed, 02 Nov 2005 12:50:10 +0200, Zeeshan <zeeshan359@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
Navigation:
[Reply to this message]
|