从mysql检索数据并在php页面上显示

Question

I am trying to make a quotation system with php code, I can retrieve data from database, but how can I multiply the data?

for example, quantity times cost.

The code echo "<td>".$row_result['"cost" * "qua"']."</td>"; is what I meant, can someone help me out with this issue.

Thanks

<?php
while($row_result=mysql_fetch_assoc($result)){
    echo "<tr>";
    echo "<td>".$row_result["id"]."</td>";
    echo "<td>".$row_result["gp_name"]."</td>";
    echo "<td>".$row_result["date"]."</td>";
    echo "<td>".$row_result["type"]."</td>";
    echo "<td>".$row_result["checkin"]."</td>";
    echo "<td>".$row_result["checkout"]."</td>";
    echo "<td>".$row_result["country"]."</td>";
    echo "<td>".$row_result["city"]."</td>";
    echo "<td>".$row_result["name"]."</td>";
    echo "<td>".$row_result["arrange"]."</td>";
    echo "<td>".$row_result["qua"]."</td>";
    echo "<td>".$row_result["cost"]."</td>";
    echo "<td>".$row_result['"cost" * "qua"']."</td>";
    echo "<td>".$row_result["reference"]."</td>";

    echo "<td><a href='update.php?id=".$row_result["id"]."'>Change</a> ";
    echo "<a href='delete.php?id=".$row_result["id"]."'>Delete</a></td>";
    echo "</tr>";
    }

?>

Answer 1

If you want to multiply two value in different array location you must access those keys individually.

$row_result["cost"] * $row_result["qua"]