Page 1 of 1

PHP and MSSQL

Posted: Tue May 24, 2005 10:53 am
by farid
:oops: Hi y'all I'm having problems with a query that I'm making in mssql with PHP, the thing is that I seem not to be able to find a way to limit the query.

Code: Select all

$sql_results = mssql_query("SELECT folio_div1 FROM bd_cac WHERE folio_div1 LIKE '%$query%' LIMIT $limit,10");
Thanks!!

Posted: Sat May 28, 2005 4:49 am
by JAM
For MSSql, try "select TOP X ..." exchanging the X with the limit.

Code: Select all

$sql_results = mssql_query("SELECT TOP $limit folio_div1 FROM bd_cac WHERE folio_div1 LIKE '%$query%'");