'; echo ''; echo 'Image'; echo 'Fruit'; echo 'Unit-price'; echo 'Order'; echo ''; echo ''; for ($i = 3; $i < $col; $i++) { //check availability error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING); $check_sql = "SELECT $a FROM inventory WHERE name = '$col_name[$i]'"; $res = mysqli_query($conn, $check_sql); $avail = mysqli_fetch_array($res); if ($avail[$a] == 0 && $avail[$a] !== null) { echo ""; } if ($goods[$i] > 0) { //display image $sql_img = "SELECT img FROM inventory WHERE name='$col_name[$i]'"; $picaddress = mysqli_query($conn, $sql_img); $img = mysqli_fetch_array($picaddress); //get unit price $sql_price = "SELECT $m FROM inventory WHERE name='$col_name[$i]'"; $res = mysqli_query($conn, $sql_price); $price = mysqli_fetch_array($res); //unit price $unitprice = $price[$m]; //total price $total += $unitprice * $goods[$i]; //display echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

'; echo ''; echo '

'; echo ' ' . $col_name[$i] . ' '; echo '

'; echo ' ￥'.$unitprice.' '; echo '

'; echo ''; echo '

'; echo ''; echo '

'; echo ''; echo '

'; } } echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Total Price: ￥ '.$total.'

'; echo ' '; if($usertype == 'buyer'){ echo 'Order'; } else{ echo 'Sell'; } echo ' '; echo '

'; } ?>