Problem with multiple joins

[eluser]JoshK[/eluser]
Oops, yes you are right. I was using an extra column which I never needed, however it never fixed the issue, just made my database a little cleaner. Thanks for that.

What's happening is in my foreach statement I have a link

Code:

<h2><a >event_id?&gt;">&lt;?=$row->event_name?&gt;</a></h2>

All works perfect with 3 joins. If I add that final join (the 'event_dates' one) every foreach after the first doesn't include the

Code:

<?=$row->event_id?>

But thanks for the other correction, it's been implemented.