Ok, I found out why the UPDATE on the table wasn't working. I wasn't
giving
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\"
enctype=\"multipart/form-data\">\n";
$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%\"
valign=\"top\">\n";
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\"
value=\"yes\">\n";
echo "No <input name=\"post[$c]\" type=\"radio\" value=\"no\"
checked>\n";
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 ==>
$id[]="$query_data[0]";
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]
