List Results Not Working
| From: | Steve Fitzgerald | Date: | Sat, 04 Aug 2001 20:30:28 +0000 |
| Subject: | List Results Not Working | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11066@lists.php.net to get a copy of this message | ||
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=\"display_call.php?ContactID=$ContactID\">
".$list["CallSubject"]."
</a>
".$list["CallStatus"]."
<br><br>";
}}