All products value total need help

[perfumbg]

Hello,
I have writen a short code that gives me an idea of how much goods i have in stock.
here is the code i used with zen cart v1.5.1

<?php
 
      $all_products_sumquery_raw = mysql_query("
SELECT SUM(products_quantity * products_price_sorter) AS grand_total
FROM products
WHERE products_quantity > '0'
");
$test1 = mysql_fetch_array($all_products_sumquery_raw);
echo '<h2>Total value: <span class="totalUred">'.number_format($test1[0], 2, ',', ' ').'</span>$.</h2>';
      ?>

Sinse i moved to 1.5.4 and coppied the code to admin/index.php the result is 0,00 (no value returned)

Does somebody knows what change must be done?

Best regards.

[Design75]

mysql_query is depricated.

It is better to use the build in sql queries.

like below.

 <?php 
$all_products_sumquery_raw = "SELECT SUM(products_quantity * products_price_sorter) AS grand_total 
                                           FROM ' . TABLE_PRODUCTS . '
                                           WHERE products_quantity > '0'"; 
$test1 = $db->Execute($all_products_sumquery_raw); 
echo '<h2>Total value: <span class="totalUred">'.number_format($test1[0], 2, ',', ' ').'</span>$.</h2>'; 
      ?>

[perfumbg]

I tested your code but is returning an error.
Just found that mysql_fetch_array is depricated too .

Thank you for your help.

[perfumbg]

I couldnt solve it by myself. I cant figure out where is the problem, no mater what i do i cant return any results even for the total products avaliable.

Any help is appreciated.

[Ajeh]

To use the $db things you need to have a:
global $db;

Try something like:

 <?php
global $db; 
$all_products_sumquery_raw = "SELECT SUM(products_quantity * products_price_sorter) AS grand_total 
                                           FROM ' . TABLE_PRODUCTS . '
                                           WHERE products_quantity > '0'"; 
$test1 = $db->Execute($all_products_sumquery_raw); 
echo '<h2>Total value: <span class="totalUred">'.number_format($test1[0], 2, ',', ' ').'</span>$.</h2>'; 
      ?>

[mc12345678]

To use the $db things you need to have a:
global $db;

Try something like:

 <?php
global $db; 
$all_products_sumquery_raw = "SELECT SUM(products_quantity * products_price_sorter) AS grand_total 
                                           FROM " . TABLE_PRODUCTS . "
                                           WHERE products_quantity > '0'"; 
$test1 = $db->Execute($all_products_sumquery_raw); 
echo '<h2>Total value: <span class="totalUred">'.number_format($test1[0], 2, ',', ' ').'</span>$.</h2>'; 
      ?>

Quotes are/were also incorrect around TABLE_PRODUCTS... See above.

To possibly also see what is wrong as reported by ZC, check your logs directory for myDebug files.