2. PHPRunner General questions
  3. Joins & Hyperlinks
This topic is locked

Joins & Hyperlinks

 		6/22/2006 9:08:11 AM
PHPRunner General questions
A
 amirgulamalil author

I have a question which mayb answered before: I read similar topics but did not understand the solution well.
I have 2 tables;

*class list*- a list of all students with their ID numbers(as PK), addresses, major, etc

course - records other course related info such as assignments, start dates etc..
I liked the the tables in a master/detail way: I have ID feild in course as a FK
Now i want to link the tables in a hyperlink manner, meaning:

Clicking on a student ID in course pulls up class list** with only the clicked student record
I am not sure how to Join the tables in the particular way i want and in a hyperlink fashion.
Any help would be highly appreciated <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2839&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2839&image=2&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2839&image=3&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2839&image=4&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
A
 		amirgulamalil author 6/22/2006

to make my question clear:
I linked the tables thru master/detail relationship,

but i get a new column with a hyperlink linking the tables in my student table called "course"... i dont want a new column, i want the ID feild with a hyperlink doing the same function as this new column
J
 		Jane 6/22/2006

Hi,
select hyperlink field in the View as dropdown box on the Formatting tab for your studentid field and use following URL prefix:

students_list.php?a=search&value=1&SearchField=N&SearchOption=Equals&SearchFor=



where N is index of your ID field in students table (0,1,2 etc.).
A
 		amirgulamalil author 6/22/2006

thanx jane,

but it dint seem to work..
i dont have students_list.php ( what file is that supposed to be?)
and can u pls explains joins? is it different from master/detail relationship?
thanx
J
 		Jane 6/23/2006

Hi,
this code works correct on my test box.
Please check that you follow all instructions.

If your project won't work you can send me detailed description of what you done and I'll help you.
A
 		amirgulamalil author 6/23/2006

It worked, thanx Jane
I got another question;
I got 1 master table (student) and several dependent tables (courses),

how can i move entries between the dependent tables?

Say a student completes course 1 and needs to be in course 2,