RE: [PHP-WIN] SQL to select a set of records
| From: | George Pitcher | Date: | Fri, 06 Feb 2004 11:30:09 +0000 |
| Subject: | RE: [PHP-WIN] SQL to select a set of records | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-22743@lists.php.net to get a copy of this message | ||
I have both access and MySQL DBs and I have to change my method for Access
to 'select top 10 [fields] from table where x=x etc order by y'
MS SQLServer may need the same.
George in Oxford
> -----Original Message-----
> From: Nadim Attari [mailto:nadim@alienworkers.com]
> Sent: 6 February 2004 11:33 am
> To: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] SQL to select a set of records
>
>
> > mysql> select * from table LIMIT 5,10; # Retrieve rows 6-15
>
> > If one argument is given, it indicates the maximum number of rows to
> return:
> > mysql> select * from table LIMIT 5; # Retrieve first 5 rows
>
> Dunno whether LIMIT works in Microsoft SQL Server ... someone may check it
> plzzz
>
> ~nadim attari
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>