[Summary view] [Print] [Text view]

   1  <TR>
   2  <TD class="pageHeading" colspan="3"><?=$pageTitle?></TD>
   3  </TR>
   4  <FORM ACTION="<?=$PHP_SELF?>" NAME="SELECT_PRODUCT" METHOD="POST">
   5  <INPUT TYPE="HIDDEN" NAME="action" VALUE="select">
   6  <?php
   7  echo "<TR>";
   8  echo "<TD class=\"main\"><BR><B>Please select a product to edit:<BR></TD>";
   9  echo "</TR>";
  10  echo "<TR>";
  11  echo "<TD class=\"main\"><SELECT NAME=\"current_product_id\">";
  12  
  13  $query = "SELECT * FROM products_description where products_id LIKE '%' AND language_id = '$languageFilter' ORDER BY products_name ASC";
  14  
  15  $result = mysql_query($query) or die(mysql_error());
  16  
  17  $matches = mysql_num_rows($result);
  18  
  19  if ($matches) {
  20  
  21     while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  22                                                                 
  23          $title = $line['products_name'];
  24          $current_product_id = $line['products_id'];
  25          
  26          echo "<OPTION VALUE=\"" . $current_product_id . "\">" . $title;
  27          
  28     }
  29  } else { echo "You have no products at this time."; }
  30     
  31  echo "</SELECT>";
  32  echo "</TD></TR>";
  33  
  34  echo "<TR>";
  35  echo "<TD class=\"main\"><input type=\"image\" src=\"" . $adminImages . "button_edit.gif\"></TD>";
  36  echo "</TR>";
  37  
  38  ?>
  39  </FORM>
  40