Posted by Jason Barnett on 01/21/05 16:53

Tim Burgan wrote:
> 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;
>

Heredoc is a strict format. the SQL; *must* be at the very beginning of
the line, so if you simply remove the whitespace before it you should be
fine.

> SQL;

SQL;

> $rs = $db_connection->execute($db_sql);
>
>
....
>
>
> Thanks
> Tim


--
Teach a man to fish...

NEW? | http://www.catb.org/~esr/faqs/smart-questions.html
STFA | http://marc.theaimsgroup.com/?l=php-general&w=2
STFM | http://www.php.net/manual/en/index.php
STFW | http://www.google.com/search?q=php
LAZY |
http://mycroft.mozdev.org/download.html?name=PHP&submitform=Find+search+plugins

• Next in thread: Using octal number from user input
• Prev in thread: Re: [PHP] [suspicious - maybe spam] Using heredocs
• Next in forum: Re: REPOST: Serving WML
• Prev in forum: Re: [PHP] REPOST: Serving WML
• Thread view: Using

[Reply to this message]