What's wrong with this PHP Line??

[Padgoi]

                if( $member['id'] )
                {
                        $SQL = $this->ipsclass->DB->query( "SELECT r.pid,r.uid,r.rating,COUNT(r.rating) as count,p.author_id FROM `ibf_ratings` as r LEFT JOI$

                        if( $this->ipsclass->DB->get_num_rows( $SQL ) )
                        {
                                $row = $this->ipsclass->DB->fetch_row( $SQL );

                                $ratingsSuffix = Array( 1 => 'is usually Agreed with.' , 'is Disagreed with a lot.' , 'has lots of pretty Gold Stars!' ,
                                                        'is Informative' , 'has been Thanked many times.' , 'ZINGGGGG!' , 'is Useful.' , 'is Funny.' ,
                                                        'has Spelling problems' , 'is Unfriendly' , 'has lots of Good Ideas!' , 'Spams alot' , 'is confusing!' , 'is Artistic!' );

                                $member['userrating'] = "<div class=\"user_rating\" style=\"background-image: url( 'style_images/rate/" . str_replace( ' ' , '' , strtolower( $this->ratings[$row['rating']] ) ) . ".png' );\"><a href=\"#\" onclick=\"return ShowRateBox( " . $member['id'] . ", this );\" title=\"" . $member['members_display_name'] . " " . $ratingsSuffix[$row['rating']] . "\" class=\"rate_button\"><img src=\"style_images/rate/p.gif\" width=\"16\" height=\"16\" alt=\"" . $member['members_display_name'] . " " . $ratingsSuffix[$row['rating']] . "\" class=\"rate_button\"></a></div>";
                        }
                }

 

 

I keep getting:

 

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in the $member line.

[per1os]

You know it may help if you posted in the [ code ] tags like suggested in the rules as because the link tags tend to be parsed out. I would suggest that and posting at least 10 lines before and after if you want an answer.

[Padgoi]

anyone please?

[MadTechie]

heres your problem

<?php

$SQL = $this->ipsclass->DB->query( "SELECT r.pid,r.uid,r.rating,COUNT(r.rating) as count,p.author_id FROM `ibf_ratings` as r LEFT JOI$

?>

[Padgoi]

here's a really dumb question:

 

Can anyone help me complete that line?

[MadTechie]

without knowing what its meant to do.. or how your database is setup.. its not easy... i assume thats a left join but no idea whats next!