MySQL Returns PHP Associative Array - but I Can't Access Array Data

Question

I have two records in the MySQL table. I am trying to use SELECT COUNT(*) AS total FROM tableA but I am not getting the results I am expecting.

The code below will echo Array ( [0] => Array ( [cnt] => 2 ) ):

// Count the amount of records in the table
$total = $wpdb->get_results( "SELECT COUNT( * ) AS total FROM tableA", 'ARRAY_A' );

echo "Total Records:" . print_r( $total );

The code below echos nothing:

// Count the amount of records in the table
$total = $wpdb->get_results( "SELECT COUNT( * ) AS total FROM tableA", 'ARRAY_A' );

echo "Total Records:" . $total[0]['total'];

How can I simplify this? What am I doing wrong? I'm racking my brain over this and I just can't get it to work.

Anand Solanki · Accepted Answer · 2013-10-14 04:57:02Z

0

try this:

<?php

$numRows = $wpdb->get_var( "SELECT COUNT( * ) AS total FROM tableA");

echo $numRows;

?>

answered Oct 14, 2013 at 4:57

Anand Solanki

3,4254 gold badges19 silver badges27 bronze badges

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

4 Comments

Mario.Hydrant Over a year ago

Thank you for your reply, but I'm afraid this does not fix the issue - it still returns blank/empty.

Anand Solanki Over a year ago

First check whether query is working. If yes then try another wordpress functions to execute it. I think query is perfect one.Have you checked this ???

Mario.Hydrant Over a year ago

Yes I have, and it was my mistake - I did not take out the , ARRAY_A argument when I changed the function, I tried it and it works! Thank you!

Anand Solanki Over a year ago

Welcome .....! Always take care of code that you paste from elsewhere.... Enjoy ........

DS. · Accepted Answer · 2013-10-14 03:49:30Z

0

Try this:

$sql = "SELECT COUNT( * ) AS total FROM tableA";
$sth = $DC->prepare($sql);
$sth->execute();
$result = $sth->fetch(PDO::FETCH_ASSOC);                
echo $result['total'];

answered Oct 14, 2013 at 3:49

DS.

3,0446 gold badges33 silver badges37 bronze badges

Comments

Krunal Shah · Accepted Answer · 2013-10-14 06:05:55Z

0

try this one

$total = $wpdb->get_results( "SELECT COUNT( * ) AS total FROM tableA", 'ARRAY_A' );

echo "Total Records:" . $total[0]['cnt'];

thanks.

answered Oct 14, 2013 at 6:05

Krunal Shah

1,42415 silver badges26 bronze badges

1 Comment

Krunal Shah Over a year ago

It is different, i have used $total[0]['cnt'] instead of your's $total[0]['total']

Collectives™ on Stack Overflow

MySQL Returns PHP Associative Array - but I Can't Access Array Data

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related