NEED HELP on this syntax.

[pokoot]

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 :(