mysql sætning skal oversættes til mssql

du skal nok over i noget

SELECT TOP $antal * FROM table WHERE id < $lastid ORDER BY id DESC

Hvis det skal være helt det samme, skal den være:

SELECT TOP $pr_side * FROM (SELECT TOP $pr_side + $vis_fra * FROM table ORDER BY id) AS t ORDER BY id DESC

Sætningen:

SELECT TOP $pr_side * FROM (SELECT TOP $pr_side + $vis_fra * FROM table ORDER BY id) AS t ORDER BY id DESC

virker ikke. Får disse beskeder:

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'FROM'. (severity 15) in C:\Programmer\Apache Group\Apache2\htdocs\Projekt\Arbejde\test.php on line 15

Warning: mssql_query() [function.mssql-query]: Query failed in C:\Programmer\Apache Group\Apache2\htdocs\Projekt\Arbejde\test.php on line 15