PHP Warning: mssql_query(): message: Incorrect syntax near ','.

[shaydes]

I am using this query to get data:

$cids = "212, 225";

$query = "select users.id as id, name, convert(text, intro) as intro from users, sections where status=1 and sections.user_id = users.id and users.id in ($cids)";

$result = mssql_query($query);

[/Code]

 

This is the message I get:

PHP Warning:  mssql_query(): message: Incorrect syntax near ','. (severity 15) in /var/www/msq/select-intro.php on line 495, referer: http://abc.domain.com/select-intro.php.

 

Before executing the query, the string looks like this:

select users.id as id, name, convert(text, intro) as intro from users, sections where status=1 and sections.user_id = users.id and users.id in (212, 225)

 

The comma separated list ($cids) is generated by imploding an array on integers. If I copy the string from debugging output, there is no PHP Warning but if I use $cids, there is.

[Muddy_Funster]

You say your values for @cids is coming from an array, yet your sample code shows it being hard set.  Could you clarify which is accurate?

[shaydes]

The values come from the database:

$query = select id from users where active =1;

...

while ($row = mssql_fetch_row($result)

$ids[$row->id] = $row->id;


The the array of ids is converted to comma separated list

$cids = implode(",", $ids);

[/Code]

 

I had used sample values to illustrate.