Sessions & Where statement

[cmccomas]

I'm trying to use a field in the session in the where statement.

I want to get the news items from the table 'news' where the field name in session (table users).

$query = "SELECT journID, journ_title, journ_author, date_format(journ_date, '%c.%d.%y')as entry_date FROM journal WHERE journ_author = $_SESSION['first_name'] ORDER BY journID DESC LIMIT 0, 7"; 

[nunomira]

hi,

guess it's this:

$fn = $_SESSION['first_name'];
$query = "SELECT journID, journ_title, journ_author, date_format(journ_date, '%c.%d.%y')as entry_date FROM journal WHERE journ_author = '$fn' ORDER BY journID DESC LIMIT 0, 7";

[cmccomas]

Thanks great!