On Thursday 14 March 2002 16:20, John Hughes wrote:
> $sql = "UPDATE parent_log
> SET
> classroom = \"$classroom\",
> homework = \"$homework\",
> library = \"$library\",
> fieldtrip = \"$fieldtrip\",
> pta = \"$pta\",
> mast = \"$mast\",
> meetings = \"$meetings\",
> other = \"
With the help of Court Shrock, who answered by original request for help, I
have managed to create an array of form data that can be fed to a mySQL
UPDATE query. In case anyone else needs to do this, here's the solution I
reached.
The existing data is read from the database and placed in cells t
), that would save me the time of re-typing a lot if you
feel it would help you.
Court
> -Original Message-
> From: John Hughes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 12, 2002 12:08 AM
> To: Shrock, Court; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Creating an arra
t = $row['mast'];
> $meetings = $row['meetings'];
> $other = $row['other'];
>
> echo <<
>value=\"$classroom\">
>
> EOD;
>
> }
> echo "<";
> ###SNIP
>
>
> > -Original Message-
>
'fieldtrip'];
$pta = $row['pta'];
$mast = $row['mast'];
$meetings = $row['meetings'];
$other = $row['other'];
echo <<
EOD;
}
echo "<";
###SNIP
> -----Original Message-
> From: John Hughes, Jomari Works [mailto:[E
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 11, 2002 10:50 PM
Subject: RE: [PHP-DB] Creating an array of mySQL results with PHP
> Well, you could use the power of PHP arrays and just name your input
fields
> in such a way that would create an array upon subm
Well, you could use the power of PHP arrays and just name your input fields
in such a way that would create an array upon submittal. For example:
Then, after submittal, you just loop through the array $log like such:
foreach($log as $week_no => $data) {
$sql = "UPDATE table SET classroo
