dflow Posted August 11, 2009 Share Posted August 11, 2009 ok im breaking my head about this form values aren't POSTED testing updating multiple tables, the update works fine, the POST action isn't <form id="form1" name="form1" method="post" action="<?php echo $edit_form;?>"> <label> <input type="text" name="StatusID" id="StatusID" /> </label> <label> <input type="submit" name="Submit" id="Submit" value="Submit" /> </label> </form> <?php $StatusID = $_POST['StatusID']; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("international", $con); $ProposalID=$_GET['PropID']; $edit_form = mysql_query("UPDATE proposals, contact_form SET contact_form.StatusID = '$StatusID', proposals.StatusID= '$StatusID',proposals.CustomerFirstName='GHigi' WHERE proposals.RequestID = contact_form.RequestID AND proposals.ProposalID = '3'") or trigger_error(mysql_error(),E_USER_ERROR); mysql_close($con); ?> Quote Link to comment https://forums.phpfreaks.com/topic/169782-post-problem/ Share on other sites More sharing options...
Maq Posted August 11, 2009 Share Posted August 11, 2009 Well "$edit_form" isn't declared until after you use it as an action. It's also has a value of a resource_id. There are still remaining issues, but fix those first. Quote Link to comment https://forums.phpfreaks.com/topic/169782-post-problem/#findComment-895710 Share on other sites More sharing options...
dflow Posted August 11, 2009 Author Share Posted August 11, 2009 i really didnt get what the problem was but it works now <form id="form1" name="form1" method="post" action="<?php echo $edit_form_action;?>"> <label> <input type="text" name="StatusID" id="StatusID" /> </label> <label> <input type="submit" name="Submit" id="Submit" value="Submit" /> </label> </form> <?php $StatusID = $_POST['StatusID']; echo $StatusID; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("international", $con); $ProposalID=$_GET['PropID']; $edit_form_action = mysql_query("UPDATE proposals, contact_form SET contact_form.StatusID = '$StatusID', proposals.StatusID= '$StatusID',proposals.CustomerFirstName='GHigi' WHERE proposals.RequestID = contact_form.RequestID AND proposals.ProposalID = '3'") or trigger_error(mysql_error(),E_USER_ERROR); mysql_close($con); ?> when using this code in this page the same POSTING problem occurs i apologize in advance for dumping all of this code like this but i just can't find the bug <form action="<?php echo $edit_form_action; ?>" method="post" name="form1" id="form1"> <table width="1000" cellpadding="0" cellspacing="0"> <col width="155" /> <col width="43" /> <col width="64" span="2" /> <tr height="20"> <td height="20" colspan="3" rowspan="2"><table width="600" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="text_field_title">Customer Details : <label> <input name="RequestID" type="hidden" id="RequestID" value="<?php echo $_GET['RID']; ?>" /> <input name="ProposalID" type="hidden" id="ProposalID" value="<?php echo $row_RsProposal['ProposalID']; ?>" /> </label></td> </tr> <tr> <td><table width="500" border="0" cellspacing="0" cellpadding="0" bgcolor="#00FF66"> <tr> <td class="text_field_title">Customer Last Name</td> <td><input type="hidden" name="CustomerLastName" value="<?php echo $row_RsProposal['CustomerLastName']; ?>" size="15" /> <span class="customer_Details_text"><?php echo $row_RsRequestDetails['CustomerLastName']; ?></span></td> <td> </td> <td><div align="left" class="text_field_title">TotalNumber: </div></td> <td><input name="TotalNumber" type="text" id="TotalNumber" value="<?php echo $row_RsProposal['TotalNumber']; ?>" size="3" /></td> </tr> <tr> <td class="text_field_title">Customer First Name</td> <td><input type="hidden" name="CustomerFirstName_heb" value="<?php echo $row_RsProposal['CustomerFirstName_heb']; ?>" size="15" /> <span class="customer_Details_text"><?php echo $row_RsRequestDetails['CustomerFirstName_heb']; ?></span></td> <td> </td> <td><div align="left" class="text_field_title">TotalNumberAdults: </div></td> <td><input name="TotalNumberAdults" type="text" id="TotalNumberAdults" value="<?php echo $row_RsProposal['TotalNumberAdults']; ?>" size="3" /></td> </tr> <tr> <td class="text_field_title">Customer Email</td> <td><input type="hidden" name="CustomerEmail" value="<?php echo $row_RsProposal['CustomerEmail']; ?>" size="23" /> <span class="customer_Details_text"><?php echo $row_RsRequestDetails['CustomerEmail']; ?></span></td> <td> </td> <td><div align="left"><span class="text_field_title">TotalNumberChildren</span>: </div></td> <td><input name="TotalNumberChildren" type="text" id="TotalNumberChildren" value="<?php echo $row_RsProposal['TotalNumberChildren']; ?>" size="3" /></td> </tr> <tr> <td> </td> <td><span class="text_field_title"> <input type="text" name="StatusID" id="StatusID" /> </span></td> <td class="text_field_title"> </td> <td class="text_field_title">TotalNumberBabies</td> <td><input name="TotalNumberBabies" type="text" id="TotalNumberBabies" value="<?php echo $row_RsProposal['TotalNumberBabies']; ?>" size="3" /></td> </tr> </table></td> </tr> <tr> <td><table width="500" border="0" cellspacing="0" cellpadding="0" bgcolor="#CCFF00"> <tr> <td colspan="4" class="destination_table_title">Customer Destination and Dates</td> </tr> <tr> <td class="text_field_title">CategoryName</td> <td><input type="text" name="CategoryName" value="<?php echo $row_RsProposal['CategoryName']; ?>" size="15" /></td> <td class="text_field_title">CountryName</td> <td><label> <select name="CountryName" id="CountryName"> <?php do { ?><option value="<?php echo $row_RsCountryList['CountryName']?>"<?php if (!(strcmp($row_RsCountryList['CountryName'], $row_RsProposal['CountryName']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsCountryList['CountryName']?></option> <?php } while ($row_RsCountryList = mysql_fetch_assoc($RsCountryList)); $rows = mysql_num_rows($RsCountryList); if($rows > 0) { mysql_data_seek($RsCountryList, 0); $row_RsCountryList = mysql_fetch_assoc($RsCountryList); } ?> </select> </label></td> </tr> <tr> <td class="text_field_title">CityName</td> <td><select name="CityName" id="CityName"> <?php do { ?><option value="<?php echo $row_RsCityList['CityName']?>"<?php if (!(strcmp($row_RsCityList['CityName'], $row_RsProposal['CityName']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsCityList['CityName']?></option> <?php } while ($row_RsCityList = mysql_fetch_assoc($RsCityList)); $rows = mysql_num_rows($RsCityList); if($rows > 0) { mysql_data_seek($RsCityList, 0); $row_RsCityList = mysql_fetch_assoc($RsCityList); } ?> </select></td> <td class="text_field_title">Region</td> <td><label> <select name="RegionName" id="RegionName"> <?php do { ?><option value="<?php echo $row_RsRegionList['RegionName']?>"<?php if (!(strcmp($row_RsRegionList['RegionName'], $row_RsProposal['RegionName']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsRegionList['RegionName']?></option> <?php } while ($row_RsRegionList = mysql_fetch_assoc($RsRegionList)); $rows = mysql_num_rows($RsRegionList); if($rows > 0) { mysql_data_seek($RsRegionList, 0); $row_RsRegionList = mysql_fetch_assoc($RsRegionList); } ?> </select> </label></td> </tr> <tr> <td colspan="4" class="text_field_title"><table width="450" border="0" cellspacing="0" cellpadding="0"> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td>DepartureDate</td> <td><input type="text" name="DepartureDate" value="<?php echo $row_RsProposal['DepartureDate']; ?>" size="8" /></td> <td> </td> <td>ReturnDate</td> <td><input type="text" name="ReturnDate" value="<?php echo $row_RsProposal['ReturnDate']; ?>" size="8" /></td> <td> </td> <td>Number of nights</td> <td> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td class="proposal_title">SET CURRENCY</td> </tr> <tr> <td><span class="text_field_title"><font color="#FF0000"> <select name="Currency" size="1" id="Currency"> <option value="Choose Currency" <?php if (!(strcmp("Choose Currency", $row_RsProposal['Currency']))) {echo "selected=\"selected\"";} ?>>Choose Currency</option> <?php do { ?><option value="<?php echo $row_RsCurrency['Sign']?>"<?php if (!(strcmp($row_RsCurrency['Sign'], $row_RsProposal['Currency']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsCurrency['Currency_Name']?></option> <?php } while ($row_RsCurrency = mysql_fetch_assoc($RsCurrency)); $rows = mysql_num_rows($RsCurrency); if($rows > 0) { mysql_data_seek($RsCurrency, 0); $row_RsCurrency = mysql_fetch_assoc($RsCurrency); } ?> </select> Currencies dollar/euro <input name="dollareuro" type="text" id="dollareuro" size="6" /> EuroShekel <label> <input name="EUROSHEKEL" type="text" id="EUROSHEKEL" size="6" /> </label> </font></span></td> </tr> </table> <table width="600" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFCC33"> <tr> <td width="132"><img src="http://ski-packages.companyltd.com/images/hotel_icon.gif" /></td> <td colspan="6" class="proposal_title">Choose property and set prices</td> </tr> <tr> <td class="proposal_title">:<span class="text_field_title">ProductID</span></td> <td width="46"><span class="text_field_title"> <input type="text" name="ProductID" value="<?php echo $row_RsProposal['ProductID']; ?>" size="6" /> </span></td> <td width="14"> </td> <td width="97"> </td> <td width="43"> </td> <td width="209" class="text_field_title"><span class="text_field_title">FINAL PRICE</span></td> <td width="34"><input name="FINALPRICE" type="text" id="FINALPRICE" onclick="KW_calcForm('FINALPRICE',1,0,'#total_price_for_accommodation','+','#Changes_Charge','+','#tourist_tax')" value="<?php echo $row_RsProposal['FINALPRICE']; ?>" size="9" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> </tr> <tr> <td class="text_field_title">Supplier Price per night</td> <td><input name="supplier_price_per_night" type="text" value="<?php echo $row_RsProposal['supplier_price_per_night']; ?>" size="7" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> <td class="text_field_title"> </td> <td class="text_field_title">Changes Charge</td> <td class="text_field_title"><input type="text" name="Changes_Charge" value="<?php echo $row_RsProposal['Changes_Charge']; ?>" size="5" /> <?php echo $row_RsProposal['Currency']; ?></td> <td class="text_field_title">FINAL PRICE SHEKEL</td> <td class="text_field_title"><input name="finalpriceshekel" type="text" onclick="KW_calcForm('finalpriceshekel',100,2,'#FINALPRICE','*','#EUROSHEKEL')" value="<?php echo $row_RsProposal['finalpriceshekel']; ?>" size="9" /></td> </tr> <tr> <td class="text_field_title">companyltd Price Per Night</td> <td><span class="text_field_title"><font color="#000033" size="2" face="Geneva, Arial, Helvetica, sans-serif"> <input name="companyltd_Price_per_night" type="text" id="companyltd_Price_per_night" value="<?php echo $row_RsProposal['companyltd_price_per_night']; ?>" size="6" /> </font><?php echo $row_RsProposal['Currency']; ?></span></td> <td class="text_field_title"> </td> <td class="text_field_title">Supplier Commission</td> <td><input type="text" name="suppplier_comission" value="<?php echo $row_RsProposal['suppplier_comission']; ?>" size="5" /> <span class="text_field_title"></span></td> <td class="text_field_title">PrePayment to Supplier</td> <td><input type="text" name="PREPAYMENT2SUPPLIER" value="<?php echo $row_RsProposal['PREPAYMENT2SUPPLIER']; ?>" size="9" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> </tr> <tr> <td class="text_field_title">Number of nights</td> <td><input type="text" name="num_nights" value="<?php echo $row_RsProposal['num_nights']; ?>" size="3" /></td> <td class="text_field_title"> </td> <td class="text_field_title">Tourist TAX</td> <td><input type="text" name="tourist_tax" value="<?php echo $row_RsProposal['tourist_tax']; ?>" size="5" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> <td class="text_field_title">Payment to Supplier on site</td> <td><input name="PAYTOSUPPLIER" type="text" id="PAYTOSUPPLIER" value="<?php echo $row_RsProposal['PAYTOSUPPLIER']; ?>" size="9" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> </tr> <tr> <td class="text_field_title">FINAL CLEANING</td> <td><input type="text" name="finalcleaning" value="<?php echo $row_RsProposal['finalcleaning']; ?>" size="6" /> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></td> <td class="text_field_title"> </td> <td class="text_field_title">Deposit Required</td> <td><input type="text" name="deposit" value="<?php echo $row_RsProposal['deposit']; ?>" size="6" /></td> <td bgcolor="#0099CC" class="text_field_title">PrePayment to company +FINALCLEANING+Changes Charge</td> <td bgcolor="#0099CC"><label> <input name="PREPAYMENT_LANIR" type="text" id="PREPAYMENT_LANIR3" onBlur="KW_calcForm('PREPAYMENT_LANIR',100,2,'#FINALPRICE','-','(','#PAYTOSUPPLIER','+','#PREPAYMENT2SUPPLIER',')')" value="<?php echo $row_RsProposal['PREPAYMENT_LANIR']; ?>" size="8"> <span class="text_field_title"><?php echo $row_RsProposal['Currency']; ?></span></label></td> </tr> <tr> <td rowspan="2" class="text_field_title"><p>Total_price_</p> <p>for_accommodation:</p></td> <td rowspan="2" class="text_field_title"><input name="total_price_for_accommodation" type="text" onclick="KW_calcForm('total_price_for_accommodation',1,0,'(','#companyltd_Price_per_night','*','#num_nights',')','+','#finalcleaning')" value="<?php echo $row_RsProposal['total_price_for_accommodation']; ?>" size="9" /> <?php echo $row_RsProposal['Currency']; ?></td> <td rowspan="2"> </td> <td rowspan="2"> </td> <td rowspan="2"> </td> <td bgcolor="#0099CC" class="text_field_title"><p> </p></td> <td rowspan="2" bgcolor="#0099CC"><label> <input name="PREPAYMENT_LANIR_SHEKEL" type="text" id="PREPAYMENT_LANIR_SHEKEL2" onBlur="KW_calcForm('PREPAYMENT_LANIR_SHEKEL',100,2,'#EUROSHEKEL','*','#PREPAYMENT_LANIR')" value="<?php echo $row_RsProposal['PREPAYMENT_LANIR_SHEKEL']; ?>" size="8"> </label> <font face="Arial, Helvetica, sans-serif">shekel</font></td> </tr> <tr> <td bgcolor="#0099CC" class="text_field_title"> </td> </tr> </table> </td> <td width="400" height="10" colspan="3" valign="top"><table width="300" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="400"><span class="text_field_title">propsal text:</span><font color="#000033" size="2" face="Geneva, Arial, Helvetica, sans-serif"> <textarea name="proposal_text_1" cols="40" rows="6" id="textarea"><?php echo nl2br($row_RsProposal['proposal_text_1']); ?></textarea> </font> <table width="400" border="0" cellspacing="0" cellpadding="0" bgcolor="#00CC99"> <tr> <td colspan="3" class="proposal_title"><img src="http://ski-packages.companyltd.com/images/rent_a_car_icon.gif" width="58" height="57" />Car Rent Proposal</td> </tr> <tr> <td colspan="3" class="proposal_title"><font color="#000033" size="2" face="Geneva, Arial, Helvetica, sans-serif"> <select name="CarRentalSupplier" id="select4"> <option value="0" <?php if (!(strcmp(0, $row_RsProposal['CarRentalSupplier']))) {echo "selected=\"selected\"";} ?>>Car Supplier</option> <?php do { ?><option value="<?php echo $row_RsCarSuppliers['SupplierID']?>"<?php if (!(strcmp($row_RsCarSuppliers['SupplierID'], $row_RsProposal['CarRentalSupplier']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsCarSuppliers['SupplierName']?></option> <?php } while ($row_RsCarSuppliers = mysql_fetch_assoc($RsCarSuppliers)); $rows = mysql_num_rows($RsCarSuppliers); if($rows > 0) { mysql_data_seek($RsCarSuppliers, 0); $row_RsCarSuppliers = mysql_fetch_assoc($RsCarSuppliers); } ?> </select> <span class="text_field_title">Car Model <select name="CarRentModel" id="CarRentModel"> <option value="Choose car Model" <?php if (!(strcmp("Choose car Model", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>Choose car Model</option> <option value="A" <?php if (!(strcmp("A", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>A</option> <option value="B" <?php if (!(strcmp("B", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>B</option> <option value="C" <?php if (!(strcmp("C", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>C</option> <option value="D" <?php if (!(strcmp("D", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>D</option> <option value="E" <?php if (!(strcmp("E", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>E</option> <option value="F" <?php if (!(strcmp("F", $row_RsProposal['CarRentModel']))) {echo "selected=\"selected\"";} ?>>F</option> </select> </span></font></td> </tr> <tr height="20"> <td width="119" height="20" class="text_field_title">CarRentFromDate</td> <td colspan="2" class="text_field_title"><label> <input name="CarRentFromDate" type="text" id="CarRentFromDate" value="<?php echo $row_RsProposal['CarRentFromDate']; ?>" size="8" /> </label></td> </tr> <tr height="20"> <td height="20" class="text_field_title">CarRentEndDate</td> <td colspan="2" class="text_field_title"><input name="CarRentEndDate" type="text" id="CarRentEndDate" value="<?php echo $row_RsProposal['CarRentEndDate']; ?>" size="8" /></td> </tr> <tr height="20"> <td height="20" class="text_field_title">car price per day</td> <td colspan="2" class="text_field_title"><label> <input name="CarRentalPrice" type="text" id="CarRentalPrice" value="<?php echo $row_RsProposal['rent_car_num_days']; ?>" size="8" /> </label></td> </tr> <tr height="20"> <td height="20" class="text_field_title">rent_car_num_days</td> <td colspan="2" class="text_field_title"><input name="rent_car_num_days" type="text" id="rent_car_num_days" value="<?php echo $row_RsProposal['CarRentalPrice']; ?>" size="4" /></td> </tr> <tr height="20"> <td height="20" class="text_field_title">carrentpricetotal</td> <td width="91" class="text_field_title"><label> <input name="carrentpricetotaldollar" type="text" id="carrentpricetotaldollar" onclick="KW_calcForm('carrentpricetotaldollar',1,0,'#CarRentalPrice','*','#rent_car_num_days')" value="<?php echo $row_RsProposal['carrentpricetotaldollar']; ?>" size="5" /> $</label></td> <td width="190" class="text_field_title"><label> <input name="carrentpricetotaleuro" type="text" id="carrentpricetotaleuro" onclick="KW_calcForm('carrentpricetotaleuro',1,0,'#dollareuro','*','#carrentpricetotaldollar')" value="<?php echo $row_RsProposal['carrentpricetotaleuro']; ?>" size="5" /> € </label></td> </tr> </table></td> </tr> </table></td> </tr> <tr height="20"> <td height="10" colspan="3" valign="top"><table width="400" border="0" cellspacing="0" cellpadding="0" bgcolor="#00CCFF"> <tr> <td colspan="6" class="proposal_title"><img src="http://ski-packages.companyltd.com/images/plane_icon.gif" alt="" width="58" height="57" />FLIGHTS PROPOSAL</td> </tr> <tr> <td colspan="6"><font color="#000033" size="2" face="Geneva, Arial, Helvetica, sans-serif"> <select name="FlightsSuplier" id="select3"> <option value="0" <?php if (!(strcmp(0, $row_RsProposal['FlightsSuplier']))) {echo "selected=\"selected\"";} ?>>Flights Supplier</option> <?php do { ?> <option value="<?php echo $row_RsFlightsSupplier['SupplierID']?>"<?php if (!(strcmp($row_RsFlightsSupplier['SupplierID'], $row_RsProposal['FlightsSuplier']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsFlightsSupplier['SupplierName']?></option> <?php } while ($row_RsFlightsSupplier = mysql_fetch_assoc($RsFlightsSupplier)); $rows = mysql_num_rows($RsFlightsSupplier); if($rows > 0) { mysql_data_seek($RsFlightsSupplier, 0); $row_RsFlightsSupplier = mysql_fetch_assoc($RsFlightsSupplier); } ?> </select> </font></td> </tr> <tr> <td width="109" class="text_field_title">flightpriceperadult</td> <td width="5" class="text_field_title"> </td> <td width="62" class="text_field_title"><input name="flightpriceperadultdollar" type="text" id="flightpriceperadultdollar" value="<?php echo $row_RsProposal['flightpriceperadultdollar']; ?>" size="5" /> $ </td> <td width="8" class="text_field_title"> </td> <td width="101" class="text_field_title">flightpriceperadult</td> <td width="115" class="text_field_title"><input name="flightpriceperadulteuro" type="text" id="flightpriceperadulteuro" onclick="KW_calcForm('flightpriceperadulteuro',1,0,'#flightpriceperadultdollar','*','#dollareuro')" value="<?php echo $row_RsProposal['flightpriceperadulteuro']; ?>" size="5" /> € </td> </tr> <tr> <td height="20" class="text_field_title">flightpriceperchild</td> <td class="text_field_title"> </td> <td class="text_field_title"><input name="flightpriceperchilddollar" type="text" id="flightpriceperchilddollar" value="<?php echo $row_RsProposal['flightpriceperchilddollar']; ?>" size="5" /> $ </td> <td class="text_field_title"><label></label></td> <td class="text_field_title">flightpriceperchild</td> <td class="text_field_title"><input name="flightpriceperchildeuro" type="text" id="flightpriceperchildeuro" onclick="KW_calcForm('flightpriceperchildeuro',1,0,'#flightpriceperchilddollar','*','#dollareuro')" value="<?php echo $row_RsProposal['flightpriceperchildeuro']; ?>" size="5" /> € </td> </tr> <tr> <td height="20" class="text_field_title">flightpriceperbaby</td> <td class="text_field_title"> </td> <td class="text_field_title"><input name="flightpriceperbabydollar" type="text" id="flightpriceperbabydollar" value="<?php echo $row_RsProposal['flightpriceperbabydollar']; ?>" size="5" /> $</td> <td class="text_field_title"><label></label></td> <td class="text_field_title">flightpriceperbaby</td> <td class="text_field_title"><input name="flightpriceperbabyeuro" type="text" id="flightpriceperbabyeuro" onclick="KW_calcForm('flightpriceperbabyeuro',1,0,'#flightpriceperbabydollar','*','#dollareuro')" value="<?php echo $row_RsProposal['flightpriceperbabyeuro']; ?>" size="5" /> € </td> </tr> <tr> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> </tr> <tr> <td class="text_field_title">totalflightsdolar</td> <td class="text_field_title"> </td> <td class="text_field_title"><label> <input name="totalflightsdolar" type="text" id="totalflightsdolar" onclick="KW_calcForm('totalflightsdolar',1,0,'(','#flightpriceperadultdollar','*','#TotalNumberAdults',')','+','(','#flightpriceperchilddollar','*','#TotalNumberChildren',')','+','(','#flightpriceperbabydollar','*','#TotalNumberBabies',')')" value="<?php echo $row_RsProposal['totalflightsdolar']; ?>" size="9" /> $ </label></td> <td class="text_field_title"> </td> <td class="text_field_title">totalflightseuro</td> <td class="text_field_title"><input name="totalflightseuro" type="text" id="totalflightseuro" onclick="KW_calcForm('totalflightseuro',1,0,'(','#flightpriceperadulteuro','*','#TotalNumberAdults',')','+','(','#flightpriceperchildeuro','*','#TotalNumberChildren',')','+','(','#flightpriceperbabyeuro','*','#TotalNumberBabies',')')" value="<?php echo $row_RsProposal['totalflightseuro']; ?>" size="9" /> €</td> </tr> <tr> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> <td class="text_field_title"> </td> </tr> </table></td> </tr> <tr height="20"> <td width="286" height="20" rowspan="2" class="text_field_title">SET FINALSupplier : <select name="SupplierID" size="1" id="SupplierID"> <option value="0" <?php if (!(strcmp(0, $row_RsProposal['SupplierID']))) {echo "selected=\"selected\"";} ?>>Select Product Supplier</option> <?php do { ?> <option value="<?php echo $row_RsApartmentSuppliers['SupplierID']?>"<?php if (!(strcmp($row_RsApartmentSuppliers['SupplierID'], $row_RsProposal['SupplierID']))) {echo "selected=\"selected\"";} ?>><?php echo $row_RsApartmentSuppliers['SupplierName']?></option> <?php } while ($row_RsApartmentSuppliers = mysql_fetch_assoc($RsApartmentSuppliers)); $rows = mysql_num_rows($RsApartmentSuppliers); if($rows > 0) { mysql_data_seek($RsApartmentSuppliers, 0); $row_RsApartmentSuppliers = mysql_fetch_assoc($RsApartmentSuppliers); } ?> </select></td> <td width="436" class="text_field_title"><font face="Geneva, Arial, Helvetica, sans-serif"><font size="2"><font face="Geneva, Arial, Helvetica, sans-serif"><font size="2"><font color="#000033">Agent Notes/ Remarks</font></font></font><font color="#000033"></font></font></font></td> <td width="7" rowspan="2" class="text_field_title"> </td> <td colspan="3"> </td> </tr> <tr height="20"> <td class="text_field_title"><font face="Geneva, Arial, Helvetica, sans-serif"><font size="2"><font face="Geneva, Arial, Helvetica, sans-serif"><font size="2"><font color="#000033"> <textarea name="agent_notes" cols="35" rows="3" id="agent_notes"><?php echo $row_RsProposal['agent_notes']; ?></textarea> </font></font></font></font></font></td> <td colspan="3"> </td> </tr> <tr height="20"> <td height="20" colspan="3" class="text_field_title">SUPPLIER CONFIRMATION REF <input name="SupplierBookingReferrence" type="text" id="SupplierBookingReferrence" value="<?php echo $row_RsProposal['SupplierBookingReferrence']; ?>" size="14" /></td> <td colspan="3"> </td> </tr> <tr height="20"> <td height="20" colspan="3" class="text_field_title">Preview Proposal | Send Proposal | <a href="edit_proposal_form.php?PropID=<?php echo $row_RsProposalList['ProposalID']; ?>">Edit Proposal</a> | Create Commitment Form | Create Service Voucher |</td> <td colspan="3"><input type="submit" name="Submit" id="Submit" value="Edit_Proposal" /></td> </tr> </table> </form> <?php $StatusID = 44; $companyltd_price_per_night = $_POST['companyltd_price_per_night']; echo $StatusID; echo $companyltd_price_per_night; $con = mysql_pconnect($hostname_international, $username_international, $password_international) or trigger_error(mysql_error(),E_USER_ERROR); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("$database_international", $con); $ProposalID=$_GET['PropID']; $edit_form_action =mysql_query("UPDATE proposals, contact_form SET contact_form.StatusID = '$StatusID', proposals.StatusID= '$StatusID',proposals.CustomerFirstName='geaorge', proposals.companyltd_price_per_night='$companyltd_price_per_night' WHERE proposals.RequestID = contact_form.RequestID AND proposals.ProposalID = '$ProposalID'") or trigger_error(mysql_error(),E_USER_ERROR); mysql_close($con); ?> Quote Link to comment https://forums.phpfreaks.com/topic/169782-post-problem/#findComment-895753 Share on other sites More sharing options...
dflow Posted August 12, 2009 Author Share Posted August 12, 2009 bump Quote Link to comment https://forums.phpfreaks.com/topic/169782-post-problem/#findComment-896079 Share on other sites More sharing options...
dflow Posted August 12, 2009 Author Share Posted August 12, 2009 ok thanks Maq all i can say is "Death to White Space" Quote Link to comment https://forums.phpfreaks.com/topic/169782-post-problem/#findComment-896246 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.