wczytywanie rekordu mysql Opcje

[zero-gravity]

Zrobiłem taki kod:

[PHP] pobierz, plaintext 
<?php
define('DB_HOST','mysql.cba.pl');
define('DB_USER','sasp1');
define('DB_PASS','marcin');
define('DB_NAME','sasp_cba_pl');
mysql_connect(DB_HOST,DB_USER,DB_PASS,true)or die(mysql_error());
mysql_select_db(DB_NAME)or die(mysql_error());
 
 
$query = mysql_query("select * from support order by data desc")or die(mysql_error());
 
echo '<table id="tab">
<tr><th><center>ID </center></th><th>NICK</th><th>WIEK</th><th>Akcja</th></tr>';
 
while($r=mysql_fetch_array($query)){
echo '<tr>';
echo '<td>'.$r['id'].'</td>';
echo '<td>'.$r['pole'].'</td>';
echo '<td>'.$r['nick'].'</td>';
echo '<td><a href="book.php?id='.$r['id'].'"> [Przeczytaj]</A><td>';
echo '</tr>';
}
 
 
 
 
 
 
 
 
echo '</table>';
?> 
[PHP] pobierz, plaintext 

A jak zrobić aby wczytało mi dany rekord? np. book.php?id=1

[sylwekqaz]

[PHP] pobierz, plaintext 
    <?php
    define('DB_HOST','localhost');
    define('DB_USER','root');
    define('DB_PASS','');
    define('DB_NAME','sasp_cba_pl');
    mysql_connect(DB_HOST,DB_USER,DB_PASS,true)or die(mysql_error());
    mysql_select_db(DB_NAME)or die(mysql_error());
 
     if (isset($_GET['id'])and !empty){
    $query = mysql_query("select * from support where id='".intval($_GET['id'])."' order by data desc")or die(mysql_error());
    } else {
    $query = mysql_query("select * from support order by data desc")or die(mysql_error());
    }
    echo '<table id="tab">
    <tr><th><center>ID </center></th><th>NICK</th><th>WIEK</th><th>Akcja</th></tr>';
 
    while($r=mysql_fetch_array($query)){
    echo '<tr>';
    echo '<td>'.$r['id'].'</td>';
    echo '<td>'.$r['pole'].'</td>';
    echo '<td>'.$r['nick'].'</td>';
    echo '<td><a href="book.php?id='.$r['id'].'"> [Przeczytaj]</A><td>';
    echo '</tr>';
    }
 
    echo '</table>';
    ?> 
[PHP] pobierz, plaintext 

oto kod.
a w pierwszym poście usuń dane do mysql'a