Display number of pending orders on main site

I would like to be able to display for our customers how many orders we currently have in our processing queue. I tried the following query, but I must have something wrong. I can't determine why it's not showing the count. Can anyone help me sort this?

$query = "select count(*) as count from " . TABLE_ORDERS . " where orders_status = '114'"; 
$result = mysql_query($query); 
$values = mysql_fetch_assoc($result); 
$num_rows = $values['total']; 
echo $num_rows;

abcisme:

I would like to be able to display for our customers how many orders we currently have in our processing queue. I tried the following query, but I must have something wrong. I can't determine why it's not showing the count. Can anyone help me sort this?

Try this:

$query = "select * from " . TABLE_ORDERS . " where orders_status = '114'"; 
              $result = mysql_query($query);
               $count = mysql_num_rows($result) ;
echo $count ; 

or this

 $query = "select * from " . TABLE_ORDERS . " where orders_status = '114'"; 
$num_rows_result = $db->Execute($query);
$num_rows = $num_rows_result->RecordCount();

Cheers
RodG

RodG:

Try this:

$query = "select * from " . TABLE_ORDERS . " where orders_status = '114'";
$result = mysql_query($query);
$count = mysql_num_rows($result) ;
echo $count ;

> 
> or this 
> ```
 $query = "select * from " . TABLE_ORDERS . " where orders_status = '114'"; 
$num_rows_result = $db->Execute($query);
$num_rows = $num_rows_result->RecordCount();

Cheers
RodG
Definitely use the latter suggestion ($db->Execute) or your customization won't work with PHP 5.5 and later (when the mysql_* functions are deprecated, i.e. no longer included).