Jump to content

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


shaydes

Recommended Posts

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.

Link to comment
Share on other sites

  • 2 weeks later...

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.

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.