pokoot
-
Posts
1 -
Joined
-
Last visited
Never
pokoot's Achievements
Newbie (1/5)
0
Reputation
-
Hi thanks for reading. I got this error running on the script, but works perfectly on the mssql gui interface: $paging = " GO WITH ordering AS ( SELECT * , ROW_NUMBER() OVER (ORDER BY type ASC , id ASC ) AS 'row_number' FROM config ) SELECT * FROM ordering WHERE row_number BETWEEN 0 AND 20 " ; mssql_query( $paging_query ); Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near 'ordering'. (severity 15) Hope some1 can help :(