proper sql query format

  • Usign this plugin, I am trying to execute SQL query
    $post_count = $wpdb->get_var( “SELECT * FROM 011wp_posts WHERE post_type = ‘post’ AND post_status=’publish’ ” );

    WHen saving it I get:
    412 Error
    Your request got filtered out due to possible security issues.
    One or more things in your request were suspicious (defective request header, invalid cookies, bad parameters)

    In phpMySQL query (SELECT * FROM 011wp_posts WHERE post_type = ‘post’ AND post_status = ‘publish’; ) works and I would get 3 rows accounted for.

    Any suggestion please.

  • The topic ‘proper sql query format’ is closed to new replies.