I'm trying to list the results of a query, but I keep getting the following error:
Parse error: parse error, expecting `T_STRING' or `T_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 = @mysql_query($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=http://www.phpbuilder.com/board/archive/index.php/\"display_call.php?ContactID=$ContactID\"> ".$list["CallSubject"]." </a> ".$list["CallStatus"]." <br><br>";
}}
?>
Parse error: parse error, expecting `T_STRING' or `T_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 = @mysql_query($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=http://www.phpbuilder.com/board/archive/index.php/\"display_call.php?ContactID=$ContactID\"> ".$list["CallSubject"]." </a> ".$list["CallStatus"]." <br><br>";
}}
?>