Dynamic page with database ino

[dullx]

Ok my previous question i solved. Now the next problem `:]
:

<?php
$query  = "SELECT cname, ctag, irc, id FROM registrated";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   echo "<b>Clan name :</b> <a href=\"clans2.php?query=".$row['id']."\">{$row['cname']}</a><br />".  

         "<b>tag :</b> {$row['ctag']} <br>" .  

         "<b>irc channel : </b>{$row['irc']} <br><br>";
} 


?> 

So now when u press 1 of the links, it goes to the page with query="idhere"

but how do i put the right info of that id + team from the database into the page :/

[thorpe]

using a where clause in your sql statement;

$query = "SELECT * FROM table WHERE id=".$_GET['query'];

[devinemke]

if (isset($_GET['id']))
{
	$result = mysql_query('SELECT * FROM registrated WHERE id = ' . $_GET['id']) or exit(mysql_error());
	print_r(mysql_fecth_assoc($result));
}
else
{
	$result = mysql_query('SELECT cname, ctag, irc FROM registrated');
	while($row = mysql_fetch_assoc($result))
	{
		echo '
		<b>Clan name :</b><a href="' . $_SERVER['PHP_SELF'] . '?id=' . $row['id'] . '">' . $row['cname'] . '</a><br>
		<b>tag :</b>' . $row['ctag'] . '<br>
		<b>irc channel :</b>' . $row['irc'] . '<br><br>';
	}
}