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.