在MySQL查询中使用会话

Question

I have a blog site with all the blog stuff including a post page the problem is i'm trying to use a php session to select a table in my database i am kinda a major noob in this but tried mysql_query("SELECT * FROM $_SESSION['SESS_LOGIN']_blog") this didn't work so i tried $user = $_SESSION['SESS_LOGIN']; $blog = _blog; "mysql_query("SELECT * FROM $user . '' . $blog") and still nothing any help would be greatly appreciated

Answer 1

Because of the ambiguity in the string interpolation, you need to wrap it in braces like this...

mysql_query("SELECT * FROM {$_SESSION['SESS_LOGIN']}_blog");