using session variable in php

[whatsthis]

Hi

Simple question thats driving me nuts.

I'm using DW8 to login userID and password. They are stored in a table users which I then need to UPDATE in PHP. I'm using the userID as the session variable. This works OK but...

In PHP how do I use the SELECT * FROM UPDATE SET WHERE userID=session variable

Thanks for your help

EDIT. I think I've got it, is it...

SELECT * FROM users;
UPDATE users SET this='that' WHERE userID== $_session[userID];

[joelucas]

You should only enclose data in quotes, not table names

SELECT * FROM users;

UPDATE users SET this='that' WHERE userID='$_SESSION['userID']';

[whatsthis]

Thanks joe I'll give that a try tonight.

😉