Originally Posted by
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:
Code:
$query = "select * from " . TABLE_ORDERS . " where orders_status = '114'";
$result = mysql_query($query);
$count = mysql_num_rows($result) ;
echo $count ;
or this
Code:
$query = "select * from " . TABLE_ORDERS . " where orders_status = '114'";
$num_rows_result = $db->Execute($query);
$num_rows = $num_rows_result->RecordCount();
Cheers
RodG
Bookmarks