Can't get data to update in Mysql

Tech17

<head>
<style type="text/css">

.style1 {
	font-size: xx-small;
}
.style2 {
	margin-top: 0px;
}
.style3 {
	text-align: center;
}
</style>
</head>

<?php
//session_start();
//Header('Cache-Control: no-cache');
//Header('Pragma: no-cache');
include "sqlconnect.php";
connect();
opendrsdatabase();
$flagdone = $_GET['flagdone'];
$todo = $_GET['todo'];
$searchterm = $_GET['searchterm'];
$auctiondate = $_GET['auctiondate'];
$update = $_GET ['update'];
$status = $_GET['status'];
$A06_Comments = $_GET['A06_Comments'];
$updatedo = $_GET['updatedo'];
$carrierid =$_GET['carrierid'];
?>
<b><h3>No Freight Search&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="index2.php">Main Menu</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="updateprobill.php">Update ProBill</a></h3>
<?
if(($todo == '')||($todo == 'Search')){
 if(($todo == 'Search')&&((!$searchterm)||(!$auctiondate))){
?>
  <font color='red'><b> You have to choose both a Carrier Id and and Enter or Scan a Pronumber</b></font><br>
<?
 }
?>
  <form method='GET' action='nofreight_probill_update.php'>
  Please Choose a Carrier Id and a ProNumber Below:<br>
  Carrier Id:
  <select name='auctiondate'>
   <option value=''>Choose a Carrier Id
<?
   $getdates="select A01_Carrier_Name from A01_Carrier_T";
   $getdatesdo=mysql_query($getdates) or die (mysql_error());
   while($getdatesdoitall=mysql_fetch_array($getdatesdo)){
?>
    <option value='<?echo $getdatesdoitall[0];?>'><?echo $getdatesdoitall[0];?>
<?
   }
?>
   </select><br>
   Search Term:<input type='text' name='searchterm'>
   <input type='submit' name='todo' value='Search'>
   </form>
<?
}

if(($todo == 'Search')&&($searchterm!='')&&($auctiondate!='')){
?>
 </b>
<form action="" method="post" style="height: 191px">
<b>
 <table style="height: 188px"><tr><td style="width: 160px; height: 69px;"><b>&nbsp;Pro Number</b></td>
	 <td style="width: 179px; height: 69px;"><b>Carrier Id</b></td>
	 <td style="width: 179px; height: 69px;"><strong>Description</strong></td>
	 <td style="width: 71px; height: 69px;"><b>&nbsp;Received<br>
	 <span class="style1">(If Received type&quot;Received&quot;</span></b></td>
	 <td style="width: 90px; height: 69px;">&nbsp; 
	 </td></tr>
<?
 $getdata="select * from A05_ProBill_T inner join A06_ProBill_Items_T inner join A01_Carrier_T where A01_DRS_Carrier_id = A05_DRS_Carrier_id and A05_Carrier_ProBill like '%$searchterm%'and A05_DRS_Freight_Id = A06_DRS_Freight_Id and A01_Carrier_Name ='$auctiondate'and A06_Comments = 'no freight'";
 $getdatado=mysql_query($getdata) or die("Can't get the Auction Lots!");
 while($getdatadoitall=mysql_fetch_array($getdatado)){
?>
  <tr style="background-color:#FFFFFF;">
   <td style="width: 160; height: 109;" valign="top">
	   <input name="whichpro" type="text" value="<? echo $getdatadoitall['A05_Carrier_ProBill'];?>" style="height: 21px"></td>
	  <td align="Left" style="width: 179; height: 109;" valign="top">
<b><input name="carrierid" type="text" value="<? echo $getdatadoitall['A06_DRS_Freight_Id'];?>" class="style2"></td>
	  <td align="Left" style="width: 179px; height: 109;" valign="top">
		  <textarea cols="20" name="A05_Carrier_Descr" rows="2"><? echo $getdatadoitall['A05_Carrier_Descr'];?>
</textarea></td>
	  <td style="width: 71; height: 109;" class="style3" valign="top">&nbsp;</form><form method="post">
		  <input name="A06_Comments" type="checkbox" value="Received"></form>
	  <b><br>
	        <input type="hidden" name="update" value="yes">
	        <input type="hidden" name="freightid" value="<? echo $getdatadoitall[3]; ?>">
	        <input type="submit" name="flagdone" value="Update Complete">
	  </b>
	  </td>
  	<td style="width: 90px; height: 109px;"></td>
  </tr>  

  <? 
}  

}
if ($update == "yes"){







                        $update = "update A06_ProBill_Items_T set A06_Comments='$A06_Comments' where A06_DRS_Freight_Id='$freightid'";                            
                        }

?>

<?

?>
 </table>
 </form>

 <?

Weedpacket

How about posting something for humans to read, instead of just stuff intended for a PHP interpreter?

Derokorian

Welcome to PHP please use the boards [NOPARSE]

[/NOPARSE] when posting php code to make it easier to read and analyze. As for your problem:

if ($update == "yes"){
$update = "update A06_ProBill_Items_T set A06_Comments='$A06_Comments' where A06_DRS_Freight_Id='$freightid'";
}

You define an update variable but you never execute the query so of course the "query" isn't producing the results you want, because you never run it.

Tech17

How do I execute that variable, I'm a little confused I thought just having the update query and the submit button would be sufficient to update the changed fields

loony383

You want to run that through the mysql_query function

if ($update == "yes"){
$update = "update A06_ProBill_Items_T set A06_Comments='$A06_Comments' where A06_DRS_Freight_Id='$freightid'";
mysql_query($update) or die (mysql_error());
}

Tech17

loony383 thanks that work for executing the form, But the data that I enter into the edit boxes is not updating the database when I Submit the form

Bonesnap

Tech17;10994200 wrote:
How do I execute that variable, I'm a little confused I thought just having the update query and the submit button would be sufficient to update the changed fields

All you're really doing is assigning a string to a variable. You need to use the mysql_query() function to actually execute it.