troubleshooting Question

Parse Error

Avatar of edvinson
edvinsonFlag for United States of America asked on
PHP
2 Comments2 Solutions222 ViewsLast Modified:
Anybody see why this is failing?

$query_equipment  = <<<SQL
"SELECT
    DATEDIFF(NOW(), date_posted) AS DaysOld,
    IF(DATEDIFF(DATE_ADD(date_posted, INTERVAL 60 DAY), NOW())<0, 'EXPIRED','CURRENT') AS Status,
    DATEDIFF(DATE_ADD(date_posted, INTERVAL 60 DAY), NOW()) AS `daysRemaining`,
    `category`.`category_name`,
    `equipment`.`equipment_id`,
    `equipment`.`category_id`,
    `equipment`.`users_id`,
    `equipment`.`equipment_name`,
    `equipment`.`equipment_description`,
    `equipment`.`price`,
    date_format(`date_posted`, '%M %e, %Y') AS `formattedDate`,
    `equipment`.`is_approved`,
    `equipment`.`phone_number`,
    `equipment`.`status`,
    `equipment`.`manufacturer`,
    `users`.`users_id` AS `users_id1`,
    `users`.`users_username`,
    `users`.`users_password`,
    `users`.`users_name`,
    `users`.`users_email`
FROM `equipment`
INNER JOIN
    `category`
    ON
    (
        `equipment`.`category_id` = `category`.`category_id`
    )
INNER JOIN
    `users`
    ON
    (
        `equipment`.`users_id` = `users`.`users_id`
    )
WHERE is_approved = '1'"
SQL;
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros