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: 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 > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php