Jump to content

POST problem

dflow

By dflow
in PHP Coding Help

Recommended Posts

dflow Advanced Member

dflow

Posted
Posted

ok im breaking my head about this

form values aren't POSTED  :facewall:

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);
?>

Link to comment
https://forums.phpfreaks.com/topic/169782-post-problem/
Share on other sites
dflow Advanced Member

dflow

Posted
  • Author
Posted

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);
?>

Link to comment
https://forums.phpfreaks.com/topic/169782-post-problem/#findComment-895753
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.