Forum Moderators: coopster

Message Too Old, No Replies

multiply function in php

         

shimeal

3:18 am on Mar 24, 2004 (gmt 0)

10+ Year Member



I am having trouble with getting two variables, $price_number1 and $quantity1 to multiply. The output looks like this:

$2.00 * 10 = 0

Here is my code:

<?php
$cartridge_brand1 = $_POST['cartridge_brand1'];
$cartridge_number1 = $_POST['cartridge_number1'];
$cartridge_price1 = $_POST['cartridge_price1'];
$quantity1 = $_POST['quantity1'];
?>
<?php
$query = "SELECT name_brand FROM cartridge_brand WHERE id_brand = '".$cartridge_brand1."'";
$result = mysql_query($query);
echo mysql_result($result, 0);
?>
</p>
<p>
<?php
$query = "SELECT name_number FROM cartridge_number WHERE id_number = '".$cartridge_number1."'";
$result = mysql_query($query);
echo mysql_result($result, 0);
?>
</p>
<p>
<?php
$query = "SELECT price_number FROM cartridge_price WHERE name_number = '".$cartridge_price1."'";
$result = mysql_query($query);
$price_number1 = mysql_result($result, 0);
echo ($price_number1);
?>
</p>
<p>
<?php echo $quantity1;?>
</p>
<p>
<?php
echo "$price_number1 * $quantity1 = "; echo $price_number1 * $quantity1;?>
</p>
</body>
</html>

Any idea as to what is causing this to happen? Is it the fact that it is seeing it as $2.00 and not as 2? How can I correct this? Thanks in advance!

mykel79

6:18 am on Mar 24, 2004 (gmt 0)

10+ Year Member



Yes, I think it is because it is seeing it as "$2" (a string) and not 2 (a number). Try to change the variable taken from the db to be a number.