Re: UPDATE syntax

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 <trini0@optonline.net> 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net