Dynamically update mysql field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have Textarea generated by while loop. How can I name it to be able to use it with my mysql update statement? Scroll down to see it
   
   
  while($i<$num)
  {
// collect all Information
$id=mysql_result($result,$i,"ID");
$RefNo=mysql_result($result,$i,"Ref_No");
$JobTitle=mysql_result($result,$i,"Job_Title");
$Category=mysql_result($result,$i,"Category");
$AssignEngineer=mysql_result($result,$i,"Assign_Engineer");
$DateReceived=mysql_result($result,$i,"Date_Received");
$DateRequired=mysql_result($result,$i,"Date_Required");
$DateAssigned=mysql_result($result,$i,"Date_Assigned");
$ProjectedCompletionDate=mysql_result($result,$i,"ProjectedCompletionDate");
$DateCompleted=mysql_result($result,$i,"Date_Completed");
$ManhourSpent=mysql_result($result,$i,"ManhourSpent");
$Status=mysql_result($result,$i,"Status");
   
  ?>

          <TBODY>
        <TR VALIGN="TOP" ALIGN="CENTER">
       <TD><? echo "$id" ?></TD>
        <TD><? echo "$RefNo" ?></TD>
  
      <TD> <P><TEXTAREA NAME=text  ROWS="10"
        COLS="40"><? echo "$JobTitle"?></TEXTAREA>
   
  <BR><INPUT TYPE="submit"
    VALUE="Update">
  <INPUT type="reset"></P></TD>
        <TD><? echo "$Category" ?></TD>
    <TD><? echo "$AssignEngineer" ?></TD>
        <TD><? echo "$DateReceived" ?></TD>
       <TD><? echo "$DateRequired" ?></TD>
        <TD><? echo "$DateAssigned" ?></TD>
        <TD><? echo "$ProjectedCompletionDate" ?></TD>
        <TD><? echo "$DateCompleted" ?></TD>
        <TD><? echo "$ManhourSpent" ?></TD>
        <TD><? echo "$Status" ?></TD>
        </TR>
        </TBODY>
   
  
    <?
 ++$i;
   }
   }




 

       
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel. 

[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux