Hey,
I have 2 tables in one db which I want to pull data from.
$query = mysql_query("SELECT * FROM clientlogic.outgoing_mail, clientlogic.incoming_mail where `date` = '$year-$month-$day' group by `agent`");
while ( $r = mysql_fetch_array($query) )
{$agent = $r["agent"];
I am attempting to build a list of agents. Is this possible?