запрос для MySQL

<?
 
$link = mysql_connect("localhost","root",""); 
 mysql_select_db("test", $link); 
 
$q = mysql_query("SELECT DISTINCT chat_1 FROM text");
 
while($r = mysql_fetch_array($q)) { 
echo "$r[text]<br/>";} 
 
?>

<?
$link = mysql_connect("localhost","root",""); 
mysql_select_db("test", $link); 
$q = mysql_query("SELECT DISTINCT chat_1 FROM text");
while($r = mysql_fetch_assoc($q)) { 
echo "$r[text]<br/>";} 
?>

<?
 
$link = mysql_connect("localhost","root",""); 
 mysql_select_db("test", $link); 
 
$q = mysql_query("SELECT DISTINCT tema_name FROM chat_1");
 
 
while($r = mysql_fetch_array($q)) { 
 
echo '<a href="list_chat.php?tema_name='.$r[tema_name].'"> '.$r[tema_name].' </a><br/>';}
 
 
?>

<?
 
 
$link = mysql_connect("localhost","root",""); 
 mysql_select_db("test", $link); 
 
 
$tema_name = $_GET['tema_name'];
 
echo "$tema_name<br/>";
 
$q = mysql_query("SELECT * FROM chat_1 order by tema_name='$tema_name' ");
 
while($r = mysql_fetch_array($q)) { 
 
echo "$r[text]<br/>";
 
}
 
?>

$q = mysql_query("SELECT text from chat_1 WHERE tema_name ='$tema_name'");

$q = mysql_query("SELECT DISTINCT chat_1 FROM text");

$q = mysql_query("SELECT DISTINCT chat_1 FROM text") or die(mysql_error());