Thanks, I actually ended up finding that in the manual this morning 🙂 I have a new problem now. LOL. Wanna take a stab at it?
My form doesnt want to pass the variables to the php script.
heres the code.
<?
$MF_PART_NO = $_GET['MF_PART_NO'];
echo "<form method=\"POST\" action=\"price.php?MF_PART_NO=$MF_PART_NO\">
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber2\">
<tr>
<td width=\"50%\">
<p align=\"right\"><font face=\"Arial\" size=\"2\">Percent off Nags List Price:</font></td>
<td width=\"50%\">
<select size=\"1\" name=\"percent\" style=\"font-size: 8pt\">
<option value=\".10\">90%</option>
<option value=\".11\">89%</option>
<option value=\".12\">88%</option>
<option value=\".13\">87%</option>
<option value=\".14\">86%</option>
<option value=\".15\">85%</option>
<option value=\".16\">84%</option>
<option value=\".17\">83%</option>
<option value=\".18\">82%</option>
<option value=\".19\">81%</option>
<option value=\".20\">80%</option>
<option value=\".21\">79%</option>
<option value=\".22\" selected>78%</option>
<option value=\".23\">77%</option>
<option value=\".24\">76%</option>
<option value=\".25\">75%</option>
<option value=\".26\">74%</option>
<option value=\".27\">73%</option>
<option value=\".28\">72%</option>
<option value=\".29\">71%</option>
<option value=\".30\">70%</option>
<option value=\".31\">69%</option>
<option value=\".32\">68%</option>
<option value=\".33\">67%</option>
<option value=\".34\">66%</option>
<option value=\".35\">65%</option>
<option value=\".36\">64%</option>
<option value=\".37\">63%</option>
<option value=\".38\">62%</option>
<option value=\".39\">61%</option>
<option value=\".40\">60%</option>
<option value=\".41\">59%</option>
<option value=\".42\">58%</option>
<option value=\".43\">57%</option>
<option value=\".44\">56%</option>
<option value=\".45\">55%</option>
<option value=\".46\">54%</option>
<option value=\".47\">53%</option>
<option value=\".48\">52%</option>
<option value=\".49\">51%</option>
<option value=\".50\">50%</option>
<option value=\".51\">49%</option>
<option value=\".52\">48%</option>
<option value=\".53\">47%</option>
<option value=\".54\">46%</option>
<option value=\".55\">45%</option>
<option value=\".56\">44%</option>
<option value=\".57\">43%</option>
</select></td>
</tr>
<tr>
<td width=\"50%\">
<p align=\"right\"><font face=\"Arial\" size=\"2\">Labor:</font></td>
<td width=\"50%\"><select size=\"1\" name=\"labor1\" style=\"font-size: 8pt\">
<option value=\"5.00\">$ 5.00</option>
<option value=\"10.00\">$ 10.00</option>
<option value=\"15.00\">$ 15.00</option>
<option value=\"20.00\">$ 20.00</option>
<option value=\"25.00\">$ 25.00</option>
<option value=\"30.00\">$ 30.00</option>
<option value=\"35.00\">$ 35.00</option>
<option value=\"40.00\">$ 40.00</option>
<option value=\"45.00\" selected>$ 45.00</option>
<option value=\"50.00\">$ 50.00</option>
<option value=\"55.00\">$ 55.00</option>
<option value=\"60.00\">$ 60.00</option>
<option value=\"65.00\">$ 65.00</option>
<option value=\"70.00\">$ 70.00</option>
<option value=\"75.00\">$ 75.00</option>
<option value=\"80.00\">$ 80.00</option>
<option value=\"85.00\">$ 85.00</option>
<option value=\"90.00\">$ 90.00</option>
<option value=\"95.00\">$ 95.00</option>
<option value=\"100.00\">$ 100.00</option>
</select></td>
</tr>
<tr>
<td width=\"50%\">
<p align=\"right\"><font face=\"Arial\" size=\"2\">Kit Pricing:</font></td>
<td width=\"50%\"><select size=\"1\" name=\"kit\" style=\"font-size: 8pt\">
<option value=\"0.00\">No Kit</option>
<option value=\"5.00\">$ 5.00</option>
<option value=\"10.00\">$ 10.00</option>
<option value=\"15.00\">$ 15.00</option>
<option value=\"20.00\">$ 20.00</option>
<option value=\"25.00\">$ 25.00</option>
<option value=\"30.00\">$ 30.00</option>
<option value=\"35.00\">$ 35.00</option>
<option value=\"40.00\">$ 40.00</option>
<option value=\"45.00\">$ 45.00</option>
<option value=\"50.00\">$ 50.00</option>
</select></td>
</tr>
</table>
<p align=\"center\"><input type=\"submit\" value=\"Submit\" name=\"B1\"><input type=\"reset\" value=\"Reset\" name=\"B2\"></p>
</form>";
?>
my price.php code is as follows:
$result2 = mysql_query("SELECT * FROM glass WHERE MF_PART_NO LIKE '$MF_PART_NO'", $db);
while (list($PART_ID, $COLOR, $ATTACH, $PREMIUM, $DESCRIP, $BLOCK_1, $BLOCK_2, $GASKET, $MOULDING, $CLIPS, $ADHESIVE, $TSB, $MF_ID, $MF_PART_NO, $PRICE, $P_DATE, $PREV_P, $P_P_DATE, $PRICE_D, $P_PROCE_D) = mysql_fetch_row($result2)) {
$MF_PART_NO = $_GET['MF_PART_NO'];
$percent = $_GET['percent'];
$labor1 = $_GET['labor1'];
$kit = $_GET['kit'];
$newprice= $PRICE * $percent;
$labor=$labor1;
$pricelabor=$labor+$newprice+$kit;
$pricelabor = round($pricelabor,2);
$valid_no="^[A-Z,]";
if (eregi($valid_no,$PRICE)){
$pricelabor="Price not Available";
}
echo "<TABLE BORDER=\"0\" width=\"40%\">";
echo " <tr>\n" .
" <TD width=\"50%\"><font color=\"#dd0000\" size=\"2\"><b>Part Number<TD width=\"30%\"><font color=\"#dd0000\" size=\"2\"> <TD width=\"30%\"><font color=\"#dd0000\" size=\"2\"><b>Price</b></td>\n" .
" </tr>";
echo " <tr>\n" .
" <TD width=\"50%\"><font color=\"#000000\" size=\"2\">$MF_PART_NO</a><TD width=\"30%\"><font color=\"#000000\" size=\"2\"> <TD width=\"30%\"><font color=\"#000000\" size=\"2\">\$$pricelabor<b>.</b> 00</td>\n" .
" </tr>";
"</table>\n";
}
?>
I dont understand why i cant get the variables from the form, percent, labor1 and kit applied to this script. Can you see anything i might be missing?
Thanks for your responce.
Michael