So, then I have a sql command for updating the data with $formvar? I would
work $domain into this because $domain is the unique identifier?
Like this:
$index=0;
for (index=0; $index < $rowcount; $index++){
$formvar=${'formvar'.$index};
$sql = "UPDATE table2 SET domain = '".$domain[$index].'" cancel =
"'.$formvar'"";
}
?
-Mike
>
> Better is:
> $index=0;
> for (index=0; $index < $rowcount; $index++){
> $formvar=${'formvar'.$index};
> }
>
> ----- Original Message -----
> From: "george Pitcher" <[EMAIL PROTECTED]>
> To: "Michael Romagnoli" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, February 22, 2002 2:40 PM
> Subject: Re: [PHP] Getting the data for MySQL and then putting it
> back withPHP - at a loss!
>
>
> > Michael,
> >
> > Been there recently!
> >
> > You want to use variable variables:
> >
> > $index=0;
> > for (index=0; $index < $rowcount; $index++){
> > $formvar='formvar'.$index;
> > $formvar=$$formvar;
> >
> > Do the last two lines for each piece of data you want to handle.
> >
> > Think about how you are isolating the formvars on the submitted page to
> > make sure that you are sure you are reading the right stuff.
> >
> > Hope this helps.
> >
> > George in Edinburgh
> >
> >
> >
> > On Fri, 2002-02-22 at 12:24, Michael Romagnoli wrote:
> > >
> > > I have a special set of information retrieved from a while
> loop that I would
> > > like a person to be able to edit and send back into a MySQL table.
> > >
> > > I know all of the basic MySQL commands for doing such, but
> the PHP side to
> > > get the input from the form to go in is really stumping me.
> > >
> > > This is what I have:
> > >
> > > ---------------------
> > >
> > > $or = 0;
> > >
> > > while($or < $orderidrows) {
> > >
> > > $orderinfo = mysql_fetch_row($orderidinfo);
> > > $domain[$or] = $orderinfo[2];
> > > $cancel[$or] = $orderinfo[3];
> > >
> > > print "<tr><td><font size=2 face=Arial>
> $domain[$or]</font></td><td><font
> > > size=2 face=Arial>Cancel This Domain?</font></td><td><font size=2
> > > face=Arial><input type=text name=confirm value='$cancel[$or]'
> > > size=3></font></td>";
> > >
> > > $or++;
> > > }
> > >
> > > ----------------------
> > >
> > > The values/data I would normally insert into the MySQL from
> the form would be
> > > $confirm, based on $domain - however, in this case, I have a
> number of rows
> > > with the same
> > > name. I've received help as far as distinguishing one row
> from another -
> > > thanks. :)
> > >
> > > The problem I am really having is trying to insert the data
> back into one
> > > particular table. You see, when I select the data, I get multiple
> > > orderid's with multiple domains attached to them. When I try
> to UPDATE the
> > > MySQL with the data, only the last orderid seems to be the one getting
> > > updated. And, to boot, I want to update based on the domain
> name (since
> > > that is unique) and ignore the orderids. I only used the
> orderids to pull
> > > the data out.
> > >
> > > So, I've been using a query like this in a loop;
> > >
> > > $update = "UPDATE table2 SET cancel='$cancel[$a]' WHERE
> domain = $domain[$a]
> > >
> > > Any suggestions? I'm getting pretty desparate here! :\
> > >
> > > Thanks,
> > >
> > > -Mike
> > >
> > >
> >
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
