如何查询Cookie变量

Question

I'm trying to create a mysql/php chat (private message) for my site using the "WHERE" clause in PHP.

SELECT * FROM (tablename) WHERE (columnname) = $_SESSION('MM_USERNAME')

However, I seem to only be able to search for plain text or my table "users.username" which brings up all results in table (not what I want). Is it possible to search from the username cookie variable?

Answer 1

Since $_SESSION('MM_USERNAME') is a string it needs to be in quotes.

$query_chat = "SELECT * FROM (tablename) WHERE (columnname) = '" . $_SESSION['MM_USERNAME'] . "'";

Using the error reporting of which ever driver you are using should return this to you. You also should be sure you sanatize that value or use a prepared statement.