Getting a parse error

[SPetty]

Can anyone help me find the error here. I must be missing something. I'm getting a:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\Inetpub\wwwroot\bowlingtourneycom\mailing_list_email.php on line 39

$website_update_text = $_POST['website_update_text'];
$sponsor_text = $_POST['sponsor_text'];

$new_tournament_header = "Newly Posted Tournaments at BowlingTourney.com";
$website_update_header = "What's Happening at BowlingTourney.com";
$sponsor_header = "...and now a word from our wonderful Tournament Sponsors!";

$mailing_list_query = "SELECT * FROM mailing_list";
$result = mysql_query($mailing_list_query);
$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
{
	$row = mysql_fetch_array($result);
	$bt_email = "";

	if ($row['all_tournaments'] == "Yes")
	{
		$t_listing_query = "SELECT * FROM t_listings WHERE date_added > '($row['last_email'])'";
		$t_listing_results = mysql_query($t_listing_query);
		$t_num_results = msql_num_rows($t_listing_results);

This is the offending line 39:
$t_listing_query = "SELECT * FROM t_listings WHERE date_added > '($row['last_email'])'";

Any help would be great.

Thanks,
Shawn

[Ludichrist]

Try this:

$t_listing_query = "SELECT * FROM t_listings WHERE date_added >'" .  $row['last_email'] . "'";

PHP won't parse anything encapsulated in single quotes.

[SPetty]

Worked like a charm!

Thanks much.

Shawn

[Ludichrist]

Glad to help.