Ok, I found out why the UPDATE on the table wasn't working.  I wasn't
the command a 'fake' value for the ID column.  Ok here is the senario.
I have a form which dumps data to cols 1,2,3,5 in a table (thats
good).  I have another script which runs a loop on the data into another
form where I have a textarea, and a checkbox which fills in col 4 and
modifies col 5.  What I need to do is when the new form submits, to pass
the textarea, checkbox & ID so I could issue a proper UPDATE.  Im able
to get it to echo the textarea & the checkbox, but no luck with the ID.
    When the new form is displayed I have the loop echo the ID, but I cant
figure out how to submit the ID array.

// Snip of problem area (Hope it doesn't look sloppy in the message)//
echo "<form action=\"$PHP_SELF?op=reply\" method=\"POST\"
$c = 0;
while($query_data = mysql_fetch_row($result)) {
        echo "<table width=\"100%\" cellspacing=\"2\" border=\"1\"
        cellpadding=\"2\" BGCOLOR=\"CCCCCC\"><tr><td width=\"50%\"
        echo "Database ID: $query_data[0]<br>\n";
           echo "Name: $query_data[1]<br><br>\n";
           echo "Question:<br> $query_data[2]\n";
           echo "<hr>\n";
        echo "Post Reply =>  Yes <input name=\"post[$c]\" type=\"radio\"        
           echo "No <input name=\"post[$c]\" type=\"radio\" value=\"no\"               
           echo "</td><td width=\"50%\" align=\"\">\n"; 
        echo "Reply:<br><textarea rows=\"4\" cols=\"50\" wrap=\"hard\"  
             name =\"Reply[]\"></textarea>\n";
        echo "</td></tr></table>\n";
        echo "<br><hr><br>\n";
        $c = $c + 1;
echo "<input type=\"submit\" value=\"Submit\">\n";
                   echo "</form>\n";
// End Snip //

I tried creating a new array at the bottom of the loop like so ==>
and using a hidden field, but that failed.  My problem is basically, how
does one
one make an array 'persist'.
I looked through the archive, and didnt find anything substantial.
If you need more info please email me.
Thanks for listening....

Gerard Samuel wrote:
   > Thanks for telling me that I was talking jibberish :)
   > OK it worked, but now I have to figure out why its only updating the
   > first row.....
   > Ill be back if I cant figure it out.
   > Thanks all
   > Tyler Longren wrote:
   >> yeah...jibberish.  Should be this:
   >> UPDATE mpn_asklee SET reply='$Reply[$i]', Post='$post[$i]' WHERE
   >> ID='$counts'"
   >> On Mon, 13 Aug 2001 15:20:17 -0400
   >> Gerard Samuel <[EMAIL PROTECTED]> wrote:
   >>> I have a database with 5 columns and cols 1,2,3 & 5 are filled.  I
   >>> want to insert into 4 and change 5.  Could I use an UPDATE command to
   >>> do this..  Here is what I have ==>
   >>> $query = "UPDATE mpn_asklee (Reply, Post) VALUES
   >>>        ('$Reply[$i]', '$post[$i]') WHERE ID = '$counts'";
   >>> $result = mysql_query($query);
   >>> If Im talking jibberish, let me know..

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to