Posted by Rik on 10/14/09 11:53

totalstranger wrote:
> Can someone please tell me why this PHP statement throws the following
> PHP error:
> Parse error: parse error, unexpected '=' in
> /var/www/html/PHP/XXXXXXXX.php on line 335 (line 335 is the Where
> portion of the script below)
>
> $query = 'SELECT Venue.*, '
> . ' CONCAT_WS(\' \', Users2.Firstname, Users2.Lastname,
> Date_Format(Venue.Vnu_Add_Date, \'%b %e, %Y %T\' )) as Mnt_Add, '
> . ' CONCAT_WS(\' \', Users.Firstname, Users.Lastname,
> Date_Format(Venue.Lastmaint, \'%b %e, %Y %T\' )) as Mnt_Data '
> . ' FROM `Venue`'
> . ' LEFT JOIN Users as Users2 ON Venue.Vnu_Add_Userid = Users2.Id'
> . ' LEFT JOIN Users ON Venue.Maint_Userid = Users.Id'
> . ' WHERE Venue.Id = '.$Id_clean;
>
>
> Similar code on other scripts works without a problem and I'm unable
> to find this error.

I cannot seem te reproduce the error with the same script, so I wouldn't
know. Are you very sure this is the EXACT script? no accidental switching of
backticks and quotes?


You do know however, that linebreaks are perfectly legal, and you dont have
concatenate your whole query?
So:
SELECT Venue.*,
CONCAT_WS(\' \', Users2.Firstname, Users2.Lastname,
Date_Format(Venue.Vnu_Add_Date, \'%b %e, %Y %T\' )) as Mnt_Add,
CONCAT_WS(\' \', Users.Firstname, Users.Lastname,
Date_Format(Venue.Lastmaint, \'%b %e, %Y %T\' )) as Mnt_Data
FROM `Venue`
LEFT JOIN Users as Users2 ON Venue.Vnu_Add_Userid = Users2.Id
LEFT JOIN Users ON Venue.Maint_Userid = Users.Id
WHERE Venue.Id = '.$Id_clean;

...works perfectly and will make your life a little easier.

Grtz,
--
Rik Wasmus

• Next in forum: Re: PHP Text editor ?
• Prev in forum: Re: Help needed on PHP Query generation
• Thread view: Re: Help needed on PHP Query generation

[Reply to this message]