MS SQL "LIMIT" function???

[himura_drew]

Hi guys,

I'm trying to implement pagination for my script with MS SQL as the back-end DataBase. I tried to read on it and found the LIMIT function that's available in MySQL. Unfortunately, the LIMIT function is not available in MS SQL. Do you have any ideas how can I implement pagination?

TYIA,
Nil-Joe

---

e.g.

<b>Previous</b> | <b>1</b> | <b>2</b> | <b>3</b> | <b>4</b> | <b>Next</b>

---

I've done this with MySQL. I don't know how to do it with MS SQL.

[Anon]

This worked for me:

/ Any old SQL query - no need for LIMIT or BETWEEN or SET ROWCOUNT or TOP /
$sql = "SELECT * FROM whatever";

/ Execute the query /
$result = mssql_query ($sql);

/ Jump to the row you want to start listing the results from (equivalent to the first integer (0) in the LIMIT 0,10 MySQL syntax) /
mssql_data_seek ($result, $start);

/ Loop through the result, using a $limit variable equivalent to the second integer of the LIMIT 0,10 syntax. /
for ($i=0;$i<$limit;$i++)
{
$row = mssql_fetch_row ($result);
...
}

[eojlin]

Gee... cool! thanks man!
🙂