All,
Needing a litlle help here.
I am trying to create a pricing tool that references a sql database called merakiquote with two tables called “mx” and “mxlicense”.
The mx table has the product being quoted and within the table has “ID”, “product name”, “description”, and “price”.
The mxlicense table has the same thing but it has its own product
The only thing I want the user to see is a dropdown menu for “product” BUT when the form is submitted, I want all the fields to show and a way to add up the price of the products selected in the mx and mxlicense tables.
For some reason the mxlicense dropdown is not showing and upon submission only the table “product” is displayed.
Any help is greatly appreciated.
<?php
echo '<form action ="quoter.php" method="POST">';
?>
<?php
$product = mysql_query ("SELECT product, description, partnumber,price FROM mx");
{
echo "<select name= 'product'</option>";
}
{
while ($row = mysql_fetch_row($product))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
}
?>
<br>
<?php
$license = mysql_query ("SELECT product, description, partnumber,price FROM mxlicense");
{
echo "<select name= 'license'</option>";
}
{
while ($test = mysql_fetch_assoc($license))
{
$array[] = $test;
}
}
?>
<br>
<?php
//submit to form request
echo '<input type="submit" value="Quote Request">';
echo '</form>'
?>