Forum Moderators: open
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15)
mysql: WOrks Fine
============================
$result = mysql_query("select * from files order by DocTitle asc limit ".$globalOffset.", 20");
============================
mssql: T_T.. huhuhuhu...
===================================
$result = mssql_query("select top 20 * from files order by DocTitle asc, m0_folderid = ".$globalOffset);
===================================
tnx in advance..
The ASC part is redundant and it will be
WHERE m0_folderid = some_value or
WHERE m0_folderid = 'some_value' depending on if some_value is numeric or a string.
if (isset($_GET["page"]))
{
$globalOffset = $_GET["page"];
$globalOffset = preg_replace( '/[^0-9]/', '', $globalOffset);
}
<quotes>else
{
$globalOffset = 0;
}</quotes>
by the ways thanks alot LifeinAsia for your help for now i figure new style in a sample way "Beta"..