if(!$get_meets = $mysqli->query("SELECT * from meets
LEFT JOIN teams as hteam on meets.meet_hometeam=hteam.team_id
LEFT JOIN teams as ateam on meets.meet_awayteam=ateam.team_id
LEFT JOIN teams as altloc on (meets.meet_altloc=altloc.team_id and meets.meet_altloc!='')
where meet_date between ($now+(4*86400)) and ($now+(5*86400) or meets.meet_id='2')")){
echo $mysqli->error;
return 0;
}
$themeet = $get_meets->fetch_object();
$mail->Subject = ' MARLINS: Are you attending '.$themeet->hteam.team_town.' at '.$themeet->ateam.team_town. ' on '.date('m/d/y G:i a',$themeet->meet_date).'?';
What I'm wondering is how to correctly reference the joined tables. I'm running into the fact that it is treating the $themeet->ateam.team_town is trated as a concatenation and not a reference to the object...help please.
