Relational Database - Understanding

[josephman1988]

Hey guys, I've moved onto learning Relational Database Design now, and - at the mo', getting my head confuzzled. =[

 

i have 3 tables:

Named accordingly.

 

I then have the client.php profile page - this being the current code:

$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 />";

}

 

::Please excuse the messy DB design, and this that and the other, I know there are rules of thumb here - but im learning =]::

 

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