inserting session name into Update Query

[jerryhughes70]

alright chaps....

 

at the moment, if I run this on my page

 

$test = mysql_real_escape_string($_POST['FOOTBALL']);
$name = 'Jerry Hughes';

$sql = "UPDATE upc
SET FOOTBALL='$test'
WHERE Name = '$name'";

$updateresult = mysql_query($sql) or die(mysql_error()); 

echo 'Picks Complete';

 

I get the result of my Select field which is named Football put into the row in my database which is Jerry Hughes.

 

BUT, What I've got is more than one username in the database, about 50 different people in fact, So I want to be able to replace the $name with the name of the person who is logged in.

 

On the page I've got a session running, as they have to log in to get to this page.

 

For instance, when they log in, I run Hi <?=$_SESSION['name']?>  which says Hi Jerry Hughes as the name I've logged in with is Jerry Hughes.

 

How do I go incorporating this into my UPDATE query above, so it takes the name of who's logged in and inserts the FOOTBALL thing into their row in the database?

 

Any help makes me a very happy chappy!

[AyKay47]

$test = mysql_real_escape_string($_POST['FOOTBALL']);
$name = $_SESSION['name'];

$sql = "UPDATE upc
SET FOOTBALL='$test'
WHERE Name = '$name'";

$updateresult = mysql_query($sql) or die(mysql_error()); 

echo 'Picks Complete';

 

note that you will need to declare session_start at the beginning of your script

[Pikachu2000]

Just assign the value of $_SESSION['name'] to $name.

 

$name = $_SESSION['name'];

[jerryhughes70]

oh... i'm such a goon, i had it all there in front of me then!

 

thank you very much!

[AyKay47]

oh... i'm such a goon, i had it all there in front of me then!

 

thank you very much!

just needed that nudge...