Unexpected T_CONSTANT_ENCAPSED_STRING error in SQL Query

Question

I am getting an unexpected T_CONSTANT_ENCAPSED_STRING error in the following SQL query:

mysql_query (UPDATE 'wp_posts' SET 'post_status' = 'publish' WHERE 'post_id' = '$id');

Can you guys see where the error might be?

Here is the full code in case it helps:

    $key = 'feed';
    $post_ids = array(2263, 2249); 

    foreach ($post_ids as $id) {
    $feedurl = get_post_custom_values($key, $id);
    $feedurlstr = implode($feedurl);

    // Ignore - it determines whether feed is live and returns $result
    LiveOrNot($feedurlstr);

    if ( $result == "live" ) {
    mysql_query (UPDATE 'wp_posts' SET 'post_status' = 'publish' WHERE 'post_id' = '$id');
    }    
    elseif ( $result == "notlive" ) {
    mysql_query (UPDATE 'wp_posts' SET 'post_status' = 'draft' WHERE 'post_id' = '$id');
    }
    endif;
    }

Daniel A. White · Accepted Answer · 2011-03-17 01:26:07Z

3

Wrap your SQL statements in quote-marks - ".

mysql_query ("UPDATE 'wp_posts' SET 'post_status' = 'publish' WHERE 'post_id' = '$id'");

answered Mar 17, 2011 at 1:26

Daniel A. White

192k49 gold badges389 silver badges473 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alex · Accepted Answer · 2011-03-17 01:29:45Z

0

mysql_query() takes a string. PHP is looking for constants interspersed with strings, which is not valid PHP grammer.

You need to delimit your strings, ' and " are popular choices, but there is also Heredoc syntax.

Collectives™ on Stack Overflow

Unexpected T_CONSTANT_ENCAPSED_STRING error in SQL Query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related