u mean like this??
<?
//> $id=mysql_result($result,$i,"ID");
while($temp = mysql_fetch_array($result)){
foreach($temp as $varNm =>$varVal){
$$varNm =$varVal;
}
/*
put your table code here
*/
}
?>
SOry just gues!
----- Original Message -----
From: "sam rumaizan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, May 21, 2007 3:24 PM
Subject: [PHP-WIN] Dynamically update mysql field
> 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.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
