problem with adding seasion information in mysql query

[gli]

 

<?php
$skypename = $_POST['skypename'];
$result = mysql_query("UPDATE users SET skypename='$skypename' WHERE id='$_SESSION['id']'") 
or die(mysql_error());  
?>

 

when i add 

WHERE id='$_SESSION['id']' 

  then

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/www/jimperija.atwebpages.com/settingsprocess.php on line 7

 

where is the problem in my code ?

thanks

[Zhadus]

<?php
$skypename = $_POST['skypename'];
$result = mysql_query('UPDATE users SET skypename=\"' . $skypename . '\" WHERE id=\"' . $_SESSION['id'] . '\"')
or die(mysql_error());  
?>

You are using the single and double quotations incorrectly.

[gli]

thnx.

but now there is new error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"lolozz\" WHERE id=\"\"' at line 1

[dennismonsewicz]

Try this:

 

$result = mysql_query('UPDATE users SET skypename= '$skypename' WHERE id="' . $_SESSION['id'] . '"')

[gli]

ouh zhadus  thnx all was okey.

 

denis thnx but in your code was some error.

 

thnx guys

[dennismonsewicz]

sorry yeah try this:

 

$result = mysql_query('UPDATE users SET skypename= '$skypename' WHERE id='" . $_SESSION['id'] . "'")

[dennismonsewicz]

did this work?

[morph07]

back to start... from your first post, the code:

WHERE id='$_SESSION['id']' 

 

you must revised it to

WHERE id='$_SESSION["id"]' 

 

another option is to assigning it to another variable....

 

[jonsjava]

<?php
$skypename = $_POST['skypename'];
$result = mysql_query("UPDATE users SET skypename='$skypename' WHERE id='{$_SESSION['id']}';") 
or die(mysql_error());  
?>