Wordpress MySQL query fails

Question

$query2 = "SELECT * FROM wp_posts WHERE post_status = 'publish'";
$result2 = mysql_query($query2);
if (!$result2) {
  die('Invalid query: ' . mysql_error());
}

if (mysql_numrows($result2) == 0) {
    echo("zero");
} else {
    echo(mysql_numrows($result2));
}

.. spent an hour on this, it should work but it doesn't, not sure where I'm going wrong.

Thanks

Should be using wpdb class to communicate with the database... codex.wordpress.org/Class_Reference/wpdb ,plus your query should work with the standard wp_query - codex.wordpress.org/Class_Reference/WP_Query — Elliott
– Elliott, Commented May 13, 2012 at 19:33
No, this isn't inside wordpress, using it externally for another purpose. — eozzy
– eozzy, Commented May 13, 2012 at 19:34
"It doesn't work" is very ambiguous. How doesn't it work? And querying SELECT COUNT(*) AS counter would be more efficient than this. — user1233508
– user1233508, Commented May 13, 2012 at 19:34
Should probably state that in the question to avoid confusion. — Elliott
– Elliott, Commented May 13, 2012 at 19:39

Polsonby · Accepted Answer · 2012-05-13 19:47:23Z

1

re. your comment: Call to undefined function Â die()

It looks like you might have some non-ASCII character in the whitespace before your die() statement. Try deleting that whitespace and reinserting it, and maybe you'll find out what the database error is

answered May 13, 2012 at 19:47

Polsonby

22.9k19 gold badges61 silver badges74 bronze badges

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

Comments

Imagine · Accepted Answer · 2012-05-13 19:41:36Z

0

You should use query like this

 $querystr = "SELECT $wpdb->posts.* FROM $wpdb->posts WHERE $wpdb->posts.post_status = 'publish'";
 $pageposts = $wpdb->get_results($querystr, OBJECT);

Should be using wpdb class to communicate with the database...

answered May 13, 2012 at 19:41

Imagine

9951 gold badge6 silver badges11 bronze badges

Comments

WMI · Accepted Answer · 2012-05-14 18:18:53Z

0

Try this:

$query2 = "SELECT * FROM wp_posts WHERE post_status = 'publish'";
$result2 = mysql_query("$query2");

Double quotes in the query.

Without the double quotes in the query, the query will look like:

$result2 = mysql_query(SELECT * FROM wp_posts WHERE post_status = 'publish');

Instead of:

$result2 = mysql_query("SELECT * FROM wp_posts WHERE post_status = 'publish'");

edited May 14, 2012 at 18:18

answered May 14, 2012 at 18:12

WMI

1591 silver badge11 bronze badges

Collectives™ on Stack Overflow

Wordpress MySQL query fails

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related