At 01:24 PM 5/30/2002, you wrote:
>Hey guys,
>I have a very simple question, I though I knew the answer but the MySql
>manual has confused me
>
>I have a simple select from a database of say...1k records...I use
>
>select id from myTable where sal>1000;
>
>Lets say this statement would n
In short, it would be "LIMIT 20,0" If I'm not mistaken. However, the db isn't going to
kick out the string
"The query returned 0-20 of 132 records" for you.
Are you trying to do database pagination? Mulitple rows spread across multiple page
views? If that's the case, PHPBuilder has an article
select count(*) from myTable where sal > 1000;
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://cantonrep.com
> --
> From: [EMAIL PROTECTED]
> Sent: Thursday, May 30, 2002 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: count...I think
>
>
> Hey guys,
> I have a ver
