?>
</td>
</tr>
<tr>
<td>Category</td>
<td>:</td>
<td><?php
echo $row["Name"];
?>
</td>
</tr>
<tr>
<td>Price</td>
<td>:</td>
<td><?php
echo 'Rp. ' . $row["Price"] . " or \$" . $rate->exchange_rate_convert("IDR", "USD", $row["Price"]);
?>
</td>
</tr>
<tr>
<?php
$cat = $row['CategoryID'];
if ($cat < 5) {
?>
<td colspan="3">
<table>
<?php
$q = "SELECT * FROM units WHERE CategoryID=1";
$res = mysql_query($q);
while ($r = mysql_fetch_array($res)) {
$id = $r["Id"];
<?php
require '../lib/Functions.php';
echo "<hr>";
$rates = new exchange_rates();
//instantiate the class
//Some Test rates
echo "1 USD equals " . $rates->exchange_rate_convert("USD", "IDR", 1) . " IDR<br>";
echo "1 IDR equals " . $rates->exchange_rate_convert("IDR", "USD", 13370.214669052) . " USD<br>";
<td>Qty</td>
<td>Price in IDR</td>
<td>Price in USD</td>
<td>Subtotal in IDR</td>
<td>Subtotal in USD</td>
<td>Action</td>
</tr>
<?php
$total = 0;
for ($i = 0; $i < count($item); $i++) {
$productID = $_SESSION['cartSystem']['item'][$i];
$unitID = $_SESSION['cartSystem']['unit'][$i];
$queryForProduct = "SELECT p.ProductName, c.Name, u.Unit, 3, pp.Price FROM products p JOIN design d ON p.DesignID = d.Id JOIN categories c ON p.CategoryID = c.Id JOIN stock s ON s.ProductID = p.Id JOIN units u ON s.UnitID = u.Id JOIN productsprice pp ON p.Id = pp.ProductID WHERE p.Id = {$productID} AND u.Id = {$unitID} AND pp.isCurrent = 1";
$res = mysql_query($queryForProduct) or die(mysql_error());
$row = mysql_fetch_array($res);
$dollar = $cur->exchange_rate_convert("IDR", "USD", $row["Price"]);
$total += $row["Price"] * $_SESSION['cartSystem']['qty'][$i];
?>
<tr>
<td><?php
echo $row["ProductName"];
?>
</td>
<td><?php
echo $row["Name"];
?>
</td>
<td><?php
echo $row["Unit"];
?>
</td>
