Re: [suspicious - maybe spam] Using heredocs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux