PHP session variables and MySQL

[jface]

I answered this from the news reader many hours ago, but it seems to have been
swallowed up by the system. Your problem lies with the quotes in
$_SESSION['validuser']. What's happening is that the first single quote inside
the square brackets is matching the single quote just before $_SESSION, turning
the rest of the string into unidentified data. There are several ways around
this. The first is to remove the quotes inside the square brackets:
$query_memberviewquery = 'SELECT * FROM artistmembers WHERE email
='$_SESSION[validuser]' ORDER BY membername ASC'; This is acceptable, but may
cause a warning notice (depending on the level of error reporting). The better
way is as follows: $query_memberviewquery = 'SELECT * FROM artistmembers WHERE
email =''.$_SESSION['validuser'].'' ORDER BY membername ASC'; What this does
is to build the query from three elements: the first part of the query as a
string, followed by the session variable, and finally, the last part, again as
a the string. -- David Powers Author, 'Foundation PHP 5 for Flash' (friends
of ED) Co-author 'PHP Web Development with DW MX 2004' (Apress)
[url]http://computerbookshelf.com[/url]

[bethan81]

thanks so much :)