Do you know how to make a counter, something like this
SELECT j++ ClientCode ClientName
so the ouput seria
1 1030 John
2 3202 Mary
3 4033 Xavier
etc
Thnak
----- Original Message -----
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Juan Carlos" <[EMAIL PROTECTED]>
Cc: "MysqlList" <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 4:03 PM
Subject: Re: Show record index, limit
> Juan Carlos wrote:
>
> >Hello Everybody
> >I using MySQL and I want to show the record id for the SELECT
> >
> >I know you can do
> >SELECT clientCode, clientName limit 20, 3
> >
> > 2030 John
> > 2040 Charles
> > 2050 Mery
> >
> >The limit show from record 21 (record id = 20) because the first start in
0
> >I want to show that record id (index, code) in the Select
> >
> > 20 2030 John
> > 21 2040 Charles
> > 22 2050 Mery
> >
> >
> >
> This is an incorrect assumption.
> There is no record id used here.
> You are dealing with array indicies,
> You are simply telling it to throw away the first 20 lines in the output
> set,
> send the next 3, and throw the rest away.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
