[SOLVED] Table Join multiple fields

[acadia]

Hi all,

 

I have a 3 table join which then populates information on the page.  This works great however I have Provider.PhoneNumber and providercontact.PhoneNumber and when I try to pull the information from the database I only get one phonenumber.

 

Im a little stuck could someone take a look?

 

 <?php 
$result = mysql_query("SELECT StudentProviderCaseManagerID, Provider.Name, Provider.Address, Provider.StreetAddress, Provider.City, Provider.PostCode, Provider.PhoneNumber, Provider.FaxNumber, Provider.WebSite, providercontact.FirstName, providercontact.Surname, providercontact.gender, providercontact.PhoneNumber, providercontact.MobileNumber, providercontact.FaxNumber, providercontact.eMail, providercontact.StreetAddress, providercontact.Suburb, providercontact.City, providercontact.POBox  FROM StudentProviderCaseManager 
JOIN provider ON (StudentProviderCaseManager.ProviderID = provider.ProviderID) JOIN providercontact
ON (StudentProviderCaseManager.ProviderContactID = providercontact.ProviderContactID) JOIN student
ON (StudentProviderCaseManager.StudentID = student.StudentID) WHERE student.StudentID = $_GET[studentID] ORDER BY StudentProviderCaseManagerID");


while($row = mysql_fetch_array($result))
  {
echo "
<table width='958px' border='0' cellspacing='0' cellpadding='0'>
  <tr>
    <td width='8%' class='style1'>Provider</td>
    <td width='15%'> </td>
    <td width='25%'> </td>
    <td colspan='2' class='style1'>Case Manager</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td width='12%'> </td>
    <td width='40%'> </td>
  </tr>
  <tr>
    <td> Name:</td>
    <td>";
echo $row['Name'];
echo "
</td>
    <td> </td>
    <td>Surname:</td>
    <td>";
echo $row['Surname'];
echo"
</td>
  </tr>
  <tr>
    <td>Address:</td>
    <td>";
echo $row['Address'];
echo"</td>
    <td> </td>
    <td>First Name:</td>
    <td>";
echo $row['FirstName'];
echo "</td>
  </tr>
  <tr>
    <td>Suburb:</td>
    <td>";
echo $row['StreetAddress'];
echo "</td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td>City:</td>
    <td>";
echo $row['City'];
echo "</td>
    <td> </td>
    <td>Gender:</td>
    <td>";
echo $row['gender'];
echo "</td>
  </tr>
  <tr>
    <td>PO Box:</td>
    <td>";
echo $row['POBox'];
echo "</td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td>Phone Number:</td>
    <td>";
echo $row['PhoneNumber'];
echo "</td>
  </tr>
  <tr>
    <td>Phone Number</td>
    <td>";
echo $row['PhoneNumber'];
echo "</td>
    <td> </td>
    <td>Mobile Number:</td>
    <td>";
echo $row['MobileNumber'];
echo "</td>
  </tr>
  <tr>
    <td>Fax Number:</td>
    <td>";
echo $row['FaxNumber'];
echo "</td>
    <td> </td>
    <td>Fax Number:</td>
    <td>";
echo $row['FaxNumber'];
echo "</td>
  </tr>
  <tr>
    <td>Website:</td>
    <td>";
echo $row['WebSite'];
echo"</td>
    <td> </td>
    <td>eMail Address:</td>
    <td>";
echo $row['eMail'];
echo "</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td>Street Address:</td>
    <td>";
echo $row['StreetAddress'];
echo "</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td>Suburb:</td>
    <td>";
echo $row['Suburb'];
echo "</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td>City:</td>
    <td>";
echo $row['City'];
echo "</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td>PO Box:</td>
    <td>";
echo $row['POBox'];
echo "</td>
  </tr>

</table>";
  


};



?>

Regards,

acadia

[acadia]

Ok I fixed it,

 

When i selected Provider.PhoneNumber in the beginging I changed it by adding an AS clause.

 

Provider.PhoneNumber AS provphonenumber

 

Regards,

acadia