php - counting number of values in an array

Question

I currently trying to do a count of how many properties are within a particular price range and the query I am running returns only a value of 1. Obviously I am doing something wrong - and it doesn't help being not so MySQL/PhP savvy.. would anyone mind lending a hand please?

Query is below:

    $apart = $wpdb->get_var("SELECT m1.post_id
    FROM hj_postmeta m1
    INNER JOIN hj_postmeta m2 ON m1.post_id = m2.post_id
    WHERE m1.meta_key = 'price'
    AND m1.meta_value
    BETWEEN 50000 AND 74999 AND m2.meta_key = 'property_type'
    AND m2.meta_value = 'apartment'");

$apartprice = count($apart);

Many thanks in advance.

let the DB do the counting SELECT count(m1.post_id) as count ... — juergen d
– juergen d, Commented Sep 23, 2012 at 19:30

Mihai Iorga · Accepted Answer · 2012-09-23 19:30:40Z

4

Use get_results as get_var function returns a single variable from the database:

$apart = $wpdb->get_results("SELECT m1.post_id
    FROM hj_postmeta m1
    INNER JOIN hj_postmeta m2 ON m1.post_id = m2.post_id
    WHERE m1.meta_key = 'price'
    AND m1.meta_value
    BETWEEN 50000 AND 74999 AND m2.meta_key = 'property_type'
    AND m2.meta_value = 'apartment'");

$apartprice = count($apart);

or COUNT all with get_var:

$apart = $wpdb->get_var("SELECT COUNT(m1.post_id)
    FROM hj_postmeta m1
    INNER JOIN hj_postmeta m2 ON m1.post_id = m2.post_id
    WHERE m1.meta_key = 'price'
    AND m1.meta_value
    BETWEEN 50000 AND 74999 AND m2.meta_key = 'property_type'
    AND m2.meta_value = 'apartment'");

$apartprice = $apart;

answered Sep 23, 2012 at 19:30

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

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

1 Comment

Plastika Over a year ago

Thank you so much, +1 for a fantastic answer!

Community · Accepted Answer · 2017-05-23 12:27:53Z

1

As long as you are straight forward interested in the number of rows:

$apart = $wpdb->get_var("....");
$apartprice = $wpdb->num_rows;

However I think Mihai Iorga's answer raises two very fair points in case you need to fetch all the data or the (as commented above by juergen d as well) count in the database if you do not actually process the resultset next to that one variable.

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Sep 23, 2012 at 19:36

hakre

200k55 gold badges454 silver badges865 bronze badges

Collectives™ on Stack Overflow

php - counting number of values in an array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related