what is the right syntax of dynamic mssql and php

5 hours solving the problem but i can find it

[nanat]

acctually im a mysql user but the company want me to use mssql..

mysql:
$result2 = mssql_query("select * from users where userID = ".$globalID);

mssql:

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15)..

whats wrong with this syntax?

$result = mssql_query("select FirstName,LastName from users where userID =" .$globalID );

[nanat]

mysql:

$result = mysql_query("select * from students order by LastName asc limit ".$globalOffset.", 20");

correct..

mssql:

$result = mssql_query("select top 20 * from files order by DocTitle asc = ".$globalOffset);

error
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '='. (severity 15) in
==============================================

what wrong with this statement?

[penders]

Is your userID field a string and needs to be quoted?

I'm unfamilar with this syntax:

$result = mssql_query("select top 20 * from files order by DocTitle asc = ".$globalOffset);

Do you need the = after asc?

[nanat]

even if this i change it with ;

$result = mssqL_query("select * top 20 from files where DocTitle = ". $globalOffset);

it doesnt work at all do think ds statement is right
= ". $globalOffset?

[penders]

$result = mssqL_query("select * top 20 from files where DocTitle = ". $globalOffset);

This does not look quite right to me. Presumably DocTitle is a string/varchar field and its value needs to be quoted in the SQL (MySQL or MSSQL)....?

ie.

$result = mssql_query("select top 20 * from files where DocTitle = '". $globalOffset."'");

[nanat]

even if i change it to dis.. the same error..

$result = mssql_query("select top 20 * from files order by DocTitle asc, m_folderid = '".$globalOffset."'");

tnx penders for helping me i really Appreciate it..
m_folderid = my primary key

[BarryStCyr]

Where is your "WHERE" clause?

[camilord]

i think the right statement is...

$result = mssql_query("select top 20 * from files m_folderid = '".$globalOffset."' order by DocTitle asc");

though i'm not into mssql.. hehehehe.. mssqll sucks! no offense to mssql fan.. :)

[camilord]

i think you also name you variable to a good one since your pointing the primary key... like;

$globalID = $_GET["id"];

$result = mssql_query("SELECT top 20 * FROM files WHERE m_folderid = '".$globalID."' ORDER BY DocTitle ASC");

[nanat]

dis statement = no result post because of where..

$result = mssql_query("SELECT top 20 * FROM files WHERE m_folderid = '".$globalOffset."' ORDER BY DocTitle ASC");

i tried dis dis script but there is an error

$result = mssql_query("SELECT top 20 * FROM files m_folderid = '".$globalOffset."' ORDER BY DocTitle ASC");
======================================================
dis is my script

if (isset($_GET["page"]))
{
$globalOffset = $_GET["page"];
$globalOffset = preg_replace( '/[^0-9]/', '', $globalOffset);
}
else
{
$globalOffset = 0;
}

[edited by: eelixduppy at 6:27 am (utc) on May 8, 2009]
[edit reason] no URLs, please [/edit]