Tekil Mesaj gösterimi - Bu diziyi nasıl bir foknkdiyona dönüştürürüz ki?

Konu Bu diziyi nasıl bir foknkdiyona dönüştürürüz ki?
03-02-2009, 20:24:48
 <tr>
      <th scope="row">2.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 1,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=2&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">3.</th>
      <th scope="row"><?
   $result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 2,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=3&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">4.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 3,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=4&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">5.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 4,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=5&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">6.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 5,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=6&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">7.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 6,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=7&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">8.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 7,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=8&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">9.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 8,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=9&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">10.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 9,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=10&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">11.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 10,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=11&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">12.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 11,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=12&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">13.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 12,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=13&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">14.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 13,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=14&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">15.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 14,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=15&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">16.</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 15,1 ;");
$a=mysql_fetch_row($result);
?>
        <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=16&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">17</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 16,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=17&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">18</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 17,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=18&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">19</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 18,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=19&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">20</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">21</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">22</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">23</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">24</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">25</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">26</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">27</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">28</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">29</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
    <tr>
      <th scope="row">30</th>
      <th scope="row"><?
$result=mysql_query("SELECT kullanicino,sinif,denemeno,soruno ,uyecevap from karne where kullanicino='$kullanicino' and sinif='$sinif' and denemeno='$denemeno'  order by soruno asc limit 19,1 ;");
$a=mysql_fetch_row($result);
?>
      <a href="/uyelik/deneme.php?sinif=<? echo $sinif;?>&denemeno=<? echo $denemeno; ?>&username=<? echo $username; ?>&soruno=20&kullanicino=<? echo $kullanicino; ?>" class="highlightit" ><img src="/gununsorusu/upload/<? echo $a[4];?>" border="0"></a></th>
    </tr>
Bu benim sınavımın cevap kağıtlarını oluşturuyor.Ama her sınıf için ayrı ayrı include ettiğim bu kod tekrarı yığını için bir fonksiyon yazayım dedim elime yüzüme bulaştırdım.Arkadaşlar bu sürekli devinen şeyi bir çırpıda zıyptıracak deli manyak bir fonksiyon önerebilen birisi var mı?