1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  2. <html>
  3. <head>
  4. <title>Your Order</title>
  5. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  6. </head>
  7.  
  8. <body>
  9. <?php 
  10.  
  11.  
  12.  
  13. // Connect to server and select databse.
  14. mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
  15. mysql_select_db("$db_name")or die("cannot select DB");
  16.  
  17. ?>
  18.  
  19. <?php
  20.  
  21. $oid = "8";
  22. $sql = "SELECT * FROM orders WHERE orderid=$oid";
  23. $query = mysql_query($sql);
  24. while($row = mysql_fetch_array($query)) {
  25.  
  26. $production=$row['products'];
  27. $productss = explode("+", $production);
  28.  
  29. $quantity=$row['quantity'];
  30. $quantities = explode("+", $quantity);
  31.  
  32. ?>
  33. <table width="212" height="56" border="0" cellpadding="0" cellspacing="0">
  34.   <tr>
  35.     <td width="108" height="19">Product</td>
  36.     <td width="19">&nbsp;</td>
  37.     <td width="85" height="19">Quantity</td>
  38.   </tr>
  39.   <tr>
  40.     <td height="18"><?php
  41. for($i = 0; $i < count($productss); $i++){
  42.   $sql = "SELECT * FROM products";
  43.   $query = mysql_query($sql);
  44.   while($row = mysql_fetch_array($query)) {
  45.       $prodid=$row['productid'];
  46.       $prodname=$row['productname'];
  47.       $prodprice=$row['price'];
  48.       if ($productss[$i]=$prodid){
  49.         echo $prodname;      echo " "; echo $prodprice;      echo " ";
  50.         echo " ";
  51.         echo "<br />";
  52.  
  53.       } //end the if
  54. 	  for($i=0; $i < count($prodid);){
  55. 	$totalprice+=$prodprice[$i]*$quantities[$i];
  56. 	 $i++;
  57. 	 }
  58.      }//ends the while
  59.    ?></td>
  60.     <td bgcolor="#CCCCCC"></td>
  61.     <td><div align="right">
  62.  <?php 
  63.   echo "<br />";
  64.     for($i = 0; $i < count($quantities); $i++){
  65.         echo $quantities[$i]; 
  66. 		echo " ";
  67.         echo "<br />";
  68.      }//end the for 
  69.  
  70.  
  71.  
  72. 	 ?>
  73.     </div></td>
  74.   </tr>
  75.   <tr>
  76.     <td height="19">Total Price </td>
  77.     <td>$</td>
  78.     <td><?php  
  79. echo $totalprice; ?></td>
  80.   </tr>
  81. </table>
  82.  
  83. <p>
  84.   <?php 
  85. }//end the first for loop
  86.  
  87.  
  88. }
  89. ?>
  90. </p>
  91. <p>&nbsp;</p>
  92. <p>&nbsp;</p>
  93. <p>&nbsp;</p>
  94. </body>
  95. </html>