List Results Not Working

[sfmnetsys]

I'm trying to list the results of a query, but I keep getting the following error:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

I must be missing something because I can't find what's causing the parse error.

Any thoughts?

$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

$display_calls_sql = "SELECT CallID,CallDateTime,CallSubject,CallStatus FROM calls WHERE ContactID = $ContactID";

$display_calls_result = @($display_calls_sql,$connection) or die(mysql_error());
$numrows = mysql_num_rows($display_calls_result);
if ($numrows>0) {
while ($list = mysql_fetch_array($display_calls_result)){
echo ".$list["CallID"]." ".$list["CallDateTime"]." <a href=\"display_call.php?ContactID=$ContactID\"> ".$list["CallSubject"]." </a> ".$list["CallStatus"]." <br><br>";

}}
?>

[[deleted]]

I guess it's right here:

echo ".$list["CallID"]." ".

[sfmnetsys]

Are you saying that is how it is or how it should be?

[[deleted]]

Ehm.. that's how it is now.. or does it look any different from what you posted? :-)

[sfmnetsys]

That is how it is. I assume you are saying that there is something wrong with the way it is. As far as you can tell, what is incorrect?

[[deleted]]

giggle.

echo ".$list["CallID"]." ".

Don't you think that first quote is the wrong place?
Split it up into quoted parts and you get:

echo
".$list["
CallID
"]."
".

So CallID is interpreted as an operator, and PHP correctly complains that it doesn't know that one.

[sfmnetsys]

If the first quote is in the wrong place then where should it be? What should the code look like?

Thanks.

[[deleted]]

Just leave the first quote and the first dot out.

[sfmnetsys]

Okay. Great! That builds the list except the list does not show the CallID.