i have 3 tables:

Named accordingly.
I then have the client.php profile page - this being the current code:
Code: Select all
$ClientId = $_GET['ClientId'];
$sql = "SELECT * FROM Client WHERE ClientId = $ClientId";
$result = mysql_query($sql);
while($ClientInfo = mysql_fetch_array($result))
{
echo "<strong>Name:</strong> {$ClientInfo['ClientName']} - <strong>Category:</strong> <br /><br />";
echo "<img src='./images/headshots/{$ClientInfo['ClientPic']}.jpg' name='{$ClientInfo['ClientName']}' /><br /><br />";
echo "<strong>Bio:<br /></strong> {$ClientInfo['ClientBio']}<br /><br />";
echo "Link Exchange: <br /><a href='{$ClientInfo['ClientExchange']}'>Click To Visit {$ClientInfo['ClientName']}'s Site</a><br /><br />";
echo "Demo:<br /> <a href='./demos/{$ClientInfo['ClientDemo']}.mp3'>Click Here For {$ClientInfo['ClientName']}'s Demo</a><br /><br />";
}So yea, I want to have another page where all clients are listed in categories, so - how would i go about that?
But, saying that, the above code is 'Ok' when getting the clients information, but what about trying to retrieve the category that the client is in?
Its hurts my brain - =[
Thanks in advanced for the help