Hello, Newbie question. And can the same SQL portion of the code be written something like... query= "UPDATE taablename SET (username, email, location) VALUEs( $username, $email, $location)";
Any reason why this Update command would not execute? // BUILD AND EXECUTE QUERY TO SAVE USER INFO INTO DATABASE TABLE query = "UPDATE forumUsers SET username = '$name' WHERE userID = '$id'"; result = @mysql_query($query); query2 = "UPDATE forumUsers SET email = '$emai' WHERE userID = '$id'"; result2 = @mysql_query($query2); query3 = "UPDATE forumUsers SET Location = '$loc' WHERE userID = '$id'"; result3 = @mysql_query($query3); / INFORM FLASH OF SUCCESS print "&/:result=Updated Thanks"; // CLOSE LINK TO DATABASE SERVER ysql_close($link); ?> Ike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
