Posted by Tim Burgan on 01/21/05 16:10

Hello,


I've just tried using heredocs [1] for the first time, but I am
receiving parse errors always on the very last line of my document.

The error is caused by my heredocs. Am I using it correctly? When I
replaced the heredoc with a string.. everything worked again.

Here's my code with heredocs (and the lines before and after for context):

/* Query the database */
$db_sql = <<<SQL

SELECT id, expiry, permissions
FROM tblStudents
UNION ALL
SELECT id, expiry, permissions
FROM tblStaff;

SQL;
$rs = $db_connection->execute($db_sql);


Here's my code without heredocs (and the lines before and after for
context) - this works fine:

/* Query the database */
$db_sql = 'SELECT id, expiry, permissions FROM tblStudents UNION ALL
SELECT id, expiry, permissions FROM tblStaff;';
$rs = $db_connection->execute($db_sql);


What am I doing wrong? Are there any requirements to using heredocs?
I'm using PHP4, Apache, Win XP.

[1]
<http://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc>

Thanks
Tim

[Back to original message]