I have the following code:
// Get members details from database
$date_previous_year = $date_year - 1;
$sql="SELECT * FROM member, financial_year_paid
WHERE member.membership_number = financial_year_paid.membership_number
AND financial_year_paid.financial_year = '$date_previous_year'
AND financial_year_paid.pay_nzagc = 'Y'
ORDER BY member.family_organisation_name";
$result = mysql_query($sql, $explorers_db);
if ($result == 0) print ("<br><b>there's been a problem.</b>");
while($myrow=mysql_fetch_array($result)) {
$page_number += 1;
$membership_number[$page_number] = $myrow["membership_number"];
$family_organisation_name[$page_number] = $myrow["family_organisation_name"];
$date_joined[$page_number] = $myrow["date_joined"];
$address[$page_number] = $myrow["address"];
$suburb[$page_number] = $myrow["suburb"];
$town[$page_number] =
$branch = $myrow['member.branch'];
The column name 'branch' is in both the 'member' and 'financial_year_paid' tables. The variable $branch above is not being assigned a value. Do I need to replace the wild card with the column names and use 'AS' etc or should doing something like 'member.branch' work or am I being totally sillly. Thanks for your help
