Problem with multiple joins

[eluser]überfuzz[/eluser]
[quote author="JoshK" date="1252490912"]ok, so it's not letting me display the html as it's written. Essentially, in the anchor tag I have included

Code:

<?=$row->event_id?>

in my foreach statement, the value is only returned for the first one, all other records the value is coming back empty. If I remove that join statement, it works perfectly.

Any ideas?[/quote]How does the MySQL string look rendered by active records?