link to table

[Anon]

hi - could someone help me - i am new to this and am trying to figure out how to create a link to a table for a distinct entry. For example, someone performs a search for a scholarship in my database and it returns the list of scholarships based on the search criteria. however i want the name of the scholarship to be a link to the details pertaining to that distinct scholarship. any ideas or examples would be much appreciated.

[bastien]

HI Spyros,

Easy one. The question really is how did you set up your tables. If all the id and short scholarships names and basic detail exist in one tables, then that tables should have a unique ID for each record. The second table, which contains all the details for each scholarship should have a matching ID field that matches the basic data in the other table.

When your query returns the results of the matches you want each one to be a link to a page that pull all the details out, right?

<a href=mypage.php?$uniqueID">Scholarship1</a> to create the link. When the link is clicked we use the the UniqueID to pull the details out with a query.

hth
Bastien