Linking Recordsets In Two Pages To Display Master And Detail Record

[Objectifnet]

What I really want to do is to be able to link two pages together using an ID, The table involved displays an image stored on the File Server that has the image details stored in the Database called. THE Database used is MySQL

"Support" on a Table Called "profiles":

The problem is how do I get this piece of codes to link to a details page called "PATRONS_DETAILS.PHP" and display information about one particular database detail. With ID given below as: recordID ".$info['id'] . "

<td valign=bottom><a href=patrons_details.php?recordID ".$info['id'] . " class=nav4>+More</a></td></tr></table>"; 
}
?>
 
/* I used this code to select a Database to use*/
mysql_select_db("support") or die(mysql_error()); 
 
//I used this tp Retrieves data from MySQL Table 
$data = mysql_query("SELECT * FROM profiles WHERE type_name = 'Patrons'") or die(mysql_error());
 
//Puts it into an array 
while($info = mysql_fetch_array( $data ))
 
// This variable calls a function that I use to shorten the output of the string 
displayed by the Database Table field called: 'profile_detail'
$text = $info['profile_detail'];
 
//DISPLAY STARTS FROM HERE[/quote] [quote]"profiles"
 
Echo "<table width=100% class=table2><tr><td valign=top rowspan=2>
 
FILE SERVER LOCATION OF THE IMAGE TO BE DISPLAYED WITH THE DATABASE FIELD STORING THE IMAGE INFO CALLED "profile_photo"
 
<img src=C:/Inetpub/wwwroot/sites/supportbridges/www/profile/".$info['profile_photo'] ."></td>";
 
THIS PORTION OF HTML AND PHP CODES DISPLAY THE DATABASE FIELD STORING THE PROFILE NAME CALLED "profile_name"  AND ITS 
CALLS THE VARIABLE FOR THE FUNCTIONS THAT SHORTENS THE "profile_detail" DATABASE FIELD INFO WITH . ".ShortenProfile($text)."
 
Echo "<td valign=top colspan=2><b>Profile:</b><b> ".$info['profile_name'] . "</b></td></tr><tr><td valign=top>".ShortenProfile($text)."</td>
 
This is the link that passes the RecordID to the next page
 
<td valign=bottom><a href=patrons_details.php?recordID=".$info['id'] . "class=nav4>+More</a></td></tr></table>"; 
}
?>

[cassbiz]

Whew :)

Your question and description is a little bit all over the place and real hard to follow.

As what I gathered from your question is the following. You want to retrieve an image from one database table and have it link together with another value that is located in a different table resulting in displaying a support page.

Is that correct?

If that is the case, read up on this thread http://www.thescripts.com/forum/thread562112.html