Trouble with SQL update!

[Snooble]

<?php
$_SESSION['point'] = "".rand(0, 10).".".rand(0, 9)."".rand(0, 9).""; 
echo $_SESSION['point'];
$result = $list['point'] + $_SESSION['point'];
$sql = "UPDATE `wmusers` SET `point` = '$result' WHERE 'username' = '$list['username']' LIMIT 1" ;
mysql_query($sql) or die ("Couldn't execute $sql: " . mysql_error()); 
?>

 

i get a parse error. It's almost definatly in this line:

 

$result = $list['point'] + $_SESSION['point'];

 

As i've no idea how to add the two numbers. lol

 

Thanks,

 

Snooble

[pocobueno1388]

Echo your SQL and see what it is printing.

 

echo $sql;

[chronister]

where are you defining $list['point']?

 

 

I ran this and it works fine... even adds the numbers together.

<?php
session_start();

$list['point']=10; // I created this var... delete it

$_SESSION['point'] = "".rand(0, 10).".".rand(0, 9)."".rand(0, 9).""; 

$result = $list['point'] + $_SESSION['point'];


echo $result;
?>

[Snooble]

Wicked, Thanks i'll have a look. I define the $list in an include up the page. I'll have a look.

 

Thank you

 

Snooble