[RESOLVED] update multible colums

[benracer]

i have this so far but can only get it to work on one colum?

<?php
session_start();
if(!session_is_registered(myusername))
{
header("location:main_login.php");
}
$myusername=$_SESSION['myusername'];
$phone=$_POST['phone'];
$first=$_POST['first'];
$last=$_POST['last'];
$add1=$_POST['add1'];
$add2=$_POST['add2'];
$add3=$_POST['add3'];
$zip=$_POST['zip'];
$email=$_POST['email'];

$user = "x";
$pass = "x";
$db = "x";
$link =  mysql_connect( "x", $user, $pass );

mysql_select_db( $db, $link ) or die ( "Couldn't open $db: ".mysql_error() );

$query = "UPDATE members SET phone='$phone' WHERE username='$myusername'";
mysql_query($query);
header("location:passwordchangecomplete.php");

?>

[PHPsites]

Hi Ben.

If I am understanding correctly, you are very close....

Try this...

$query = "UPDATE members SET phone='$phone', first = '$first', last ='$last', add1='$add1', add2='$add2', add3='$add3', zip='$zip', email='$email WHERE username='$myusername'";

Good luck.

[benracer]

thsnks got it!! just missed the commas,
great!