acadia Posted July 22, 2009 Share Posted July 22, 2009 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 Quote Link to comment Share on other sites More sharing options...
acadia Posted July 22, 2009 Author Share Posted July 22, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.