Display number of pending orders on main site

[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?

$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;

[RodG]

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

[lat9]

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).