acadia Posted July 22, 2009 Share Posted July 22, 2009 Hi All, I have a 3 table join that works well however I would only like to show the trainers information acording to the StudentID which is passed through a URL from a previous page. Here is my code: <?php $result = mysql_query("SELECT STrainerID, student.FirstName, student.Surname, trainer.FirstName , trainer.Surname, trainer.NZQANumber, trainer.Address, trainer.City, trainer.PostCode, trainer.PhoneNumber, trainer.MobileNumber, trainer.eMail FROM studenttrainer JOIN trainer ON (studenttrainer.TrainerID = trainer.TrainerID) JOIN student ON (studenttrainer.StudentID = student.StudentID) ORDER BY STrainerID"); while($row = mysql_fetch_array($result)) { echo $row['FirstName'] . " " . $row['Surname']; echo "<br />"; echo $row['NZQANumber'] . " " . $row['eMail']; echo "<br />"; }; ?> Could you please take a look, Thanks, acadia Link to comment https://forums.phpfreaks.com/topic/166903-passing-url-on-table-join/ Share on other sites More sharing options...
gijew Posted July 22, 2009 Share Posted July 22, 2009 There's no 'WHERE' conditional in your query. WHERE student.StudentID = $_GET[id] Ex: www.site.com?id=2 Link to comment https://forums.phpfreaks.com/topic/166903-passing-url-on-table-join/#findComment-880030 Share on other sites More sharing options...
acadia Posted July 22, 2009 Author Share Posted July 22, 2009 Thank you for your help that worked wonders! Link to comment https://forums.phpfreaks.com/topic/166903-passing-url-on-table-join/#findComment-880107 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.