Are you talking about editing mutiple rows at the same time?
if so there is no efficient way to check what row has been edited and which
haven't. What I would is use HTML variable arrays for the names of the
fields.
example you have <input type='text' name='FirstName' size='20'
maxlength='20' value='Allison' > change the name attribute to name =
[data][$id][FirstName], so now you have all variables grouped (note the use
if a fixed index 'data', explination in foreach loop ). Then your script
will loop through the POST variables and do sequential UPDATES
example
foreach ($_POST[data] as $ID => $Field) {
$query = " Update tablename Set First = '$Field[FirstName'], Last =
'$Field[LastName'], .... Where id = $ID"; #List all fields in the set clause
mysql_query($query);
}
The reason for the initial 'data' index is so you can safely loop through a
cetrain part of the post array. If you left that out you would deal with
extra variables like submit, and other hidden fields.
It's a little hard to work with multi-dimensional arrays, so what I usually
do to help me is use the var_dump() on the passed POST array.
So take a look at var_dimp(), HTML with array indexes, the foreach loop
construct.
HOWEVER, if you need to just let the user edit 1 row, what you have is fine
all you have to do is pass the id number thourgh a HTML hidden field. So
when you pull the rest of the fields and spitting out HTML spit this out
somewhere in between the <form> tags :: <input type='hidden' name='id'
value='$id' >
Bobby
"Matt Hedges" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Many hanks for ya'lls help earlier.
>
> I've figured out how to pull the data and edit it:
> http://www.hedges.org/aoii/olemiss/updatesister.php
>
> However, for some reason I can't get it to edit whatever row. In the code
> (pasted below) I have to specificy $id=row to edit...
>
> I can't figure out how to make it to where the user can select the field
> (which is the id/row) and edit it. I've tried putting a ?id=# at the end
of
> the url, but that doesn't work... Any thoughts? So what I want is where
it
> says
>
> $id=1
>
> to have it someway where that is a variable that the user can define...
>
>
>
>
> Thank you.
> Matt
>
>
>
> --
> ___________________________
> | Matt Hedges
> | http://hedgesinnovations.com
> |
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
