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 = "9";
  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. echo "<BR> <font color = 'red' >this is the first quantity "+$quantity;
  31. $quantities = explode("+", $quantity);
  32.  
  33. ?>
  34. <table width="212" height="79" border="0" cellpadding="0" cellspacing="0">
  35.   <tr>
  36.     <td width="117">Product</td>
  37.     <td width="23"> </td>
  38.     <td width="72">Quantity</td>
  39.   </tr>
  40.   <tr>
  41.     <td height="19"><?php
  42.  
  43.  
  44. for($i = 0; $i < count($productss); $i++){
  45.   $sql = "SELECT * FROM products";
  46.   $query = mysql_query($sql);
  47.   while($row = mysql_fetch_array($query)) {
  48.       $prodid=$row['productid'];
  49.       $prodname=$row['productname'];
  50.       $prodprice=$row['price'];
  51.       if ($productss[$i]=$prodid){
  52.         echo $prodname;
  53.         echo " ";
  54.         echo $prodprice;
  55.         echo " ";
  56.         echo "<br />";
  57. 		echo "this is the quantity ".$quantities[i];
  58.       } //end the if
  59.      }//ends the while
  60.    ?></td>
  61.     <td bgcolor="#CCCCCC"></td>
  62.     <td><div align="right">
  63.  <?php 
  64.     for($i = 0; $i < count($quantities); $i++){
  65.            echo $i; 
  66.            echo "<br>";
  67.            echo $quantities[$i]; 
  68.            echo "<br />";
  69.      }//end the for ?>
  70.     </div></td>
  71.   </tr>
  72.   <tr>
  73.     <td>Total Price </td>
  74.     <td>$</td>
  75.     <td> </td>
  76.   </tr>
  77. </table>
  78.  
  79. <p>
  80.   <?php 
  81. }//end the first for loop
  82.  
  83.  
  84. }
  85. ?>
  86. </p>
  87. <p> </p>
  88. <p> </p>
  89. <p> </p>
  90. </body>
  91. </html>