Re: [PHP-DB] List Results Not Working

2001-08-05 Thread Miles Thompson

I think Hugh nailed the problem, but when a script throws errors it's often 
helpful to save it with a .phps extension and call it from your browser. 
That often shows errors in syntax if a line isn't the colour you expect. It 
also forces you to look at it differently because the colourization often 
differs from your normal editor.

I assume that by now this glitch is well behind you.

Cheers - Miles

At 04:30 PM 8/4/01 -0400, Steve Fitzgerald wrote:
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 ($numrows0) {
   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]. brbr;

   }}




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] List Results Not Working

2001-08-04 Thread Steve Fitzgerald

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 ($numrows0) {
  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]. brbr;

  }}




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]