Why wont this update query work?

[zartzar]

It wont update the database 

 

$query='UPDATE users SET name='.$_POST['username'].', location='.$_POST['location'].', email='.$_POST['email'].', password='.$_POST['password'].' WHERE userid='.$_SESSION['user'].'	 ';

[bh]

Whats the error message?

 

Anyway you should set strings into quotes:

$query='UPDATE users SET name=\''.$_POST['username'].'\', ...

[fenway]

It wont update the database 

 

$query='UPDATE users SET name='.$_POST['username'].', location='.$_POST['location'].', email='.$_POST['email'].', password='.$_POST['password'].' WHERE userid='.$_SESSION['user'].'	 ';

Next time, read the rules about posting questions on this forum.

[awjudd]

I believe that the error you are getting caused by the exact thing that bh was saying ... your strings aren't in quotes, so it looks in the database for those fields and when it can't find a field called 'bobo' (assuming $_POST [ 'username' ] = 'bobo' ) then it'll error.

 

~juddster