How to LIMIT results in an html php/sql query?

Hi,

I need to limit results in the following query type:

http://www.somewhere.com/php/sql-a...ql_order=&pos=1

I found a reference that says I should be able to use LIMIT x[,y], but
I don't know where/exactly how to add that to the string. Once I know
what it's supposed to look like, and can write something to generate
it.

If someone could post an example using the above and limiting the
output to 100 records starting at position 1, that would be great.LIMIT isn't a standard SQL feature. It is supported by MySQL but not SQL
Server.

Take a look at the following alternative solutions:
http://www.aspfaq.com/show.asp?id=2120

--
David Portas
SQL Server MVP
--