[SOLVED] Driving me crazy --

[elentz]

I must not be seeing the forest for the trees!  I have a query that works fine in phpmyadmin.  I use phpmyadmin to create the php code.  When I run the query all I get is an output of the query.  I know this is incredibly simple but I just can't see the error.  Thanks for looking at this.

<?//**********************Database Connection*************

      $conn = mysql_connect("localhost", "admin", "9axmy425");
      mysql_select_db ('vtigercrm50',$conn);

//******************************************************





$sql = 'SELECT SUM((vtiger_inventoryproductrel.quantity) * (vtiger_inventoryproductrel.listprice))'
        . ' from vtiger_inventoryproductrel'
        . ' where vtiger_inventoryproductrel.id = \'17193\'';
$result = mysql_query($sql,$conn);
Echo "$sql";
?>

[Daukan]

You didn't fetch a result set and mysql returns the row as an numerically indexed array, so call the element by the index

<?php
//**********************Database Connection*************

      $conn = mysql_connect("localhost", "admin", "9axmy425");
      mysql_select_db ('vtigercrm50',$conn);

//******************************************************

$sql = 'SELECT SUM((vtiger_inventoryproductrel.quantity) * (vtiger_inventoryproductrel.listprice))'
        . ' from vtiger_inventoryproductrel'
        . ' where vtiger_inventoryproductrel.id = \'17193\'';
$result = mysql_query($sql,$conn);
$row = mysql_fetch_row($result);
echo $row[0];
?>

[elentz]

Thanks Daukan That worked just right with one exception.  I got the  result I wanted which was 9350.15000.  How do I make that 9350.15?  And to take it a step further how do I make it 9,350.15?

 

Thanks for all your help!

[tippy_102]

The info on this page will help you with the formatting:

http://ca3.php.net/number_format

[elentz]

Thanks Guys for all your help!!