Code: Select all
<?php $Selected_DB = mysql_select_db ("highdollaritems");?>
<?php
$baseProduct = $_POST["selectedProduct"];
echo $baseProduct;// Test to see if value is there
$baseProductQuery = "SELECT * FROM BaseProducts WHERE BaseProducts.SWProductName = '$baseProduct'";
$result1 = mysql_query($baseProductQuery);
$row1 = mysql_fetch_assoc($result1);
$baseProductUId = $row1['UniqueID'];
echo $baseProductUId; // Test to see if value is there
?>
<?php
$query = "SELECT * FROM `Accessories` WHERE Accessories.UniqueID = '$baseProductUId'";
$result2 = mysql_query($query);
while ($row = mysql_fetch_array($result2)) {
$UniqueID[] = $row['UniqueID'];
$SWAccessoryID[] = $row['SWAccessoryID'];
$SWAccessoryName[] = $row['SWAccessoryName'];
$AccessoryDescription[] = $row['AccessoryDescription'];
$Price[] = $row['Price'];
}
?>
<SELECT name = "SWAccessoryName" size="1" id="Combobox1">
<?php
$option = "<option VALUE=\"Select a Pool Package\">Please select a Pool Package</option> \n";
for ($i = 0; $i < COUNT($SWAccessoryName); $i++) {
$option .= "<option ";
$option .= "value=\"$SWAccessoryName[$i] $$Price[$i]\">$SWAccessoryName[$i] $$Price[$i]</option> \n";
}
echo $option;
?>
</SELECT>
<INPUT name="SubmitForm" type="submit" class="orderInputFields" value="Create Sales Order"></TD>