<?php
//Попълвате данните за свързване
$connect = mysql_connect("ХОСТ", "ПОТРЕБИТЕЛ", "ПАРОЛА");
$select_db = mysql_select_db("БАЗА ДАННИ");
mysql_query('set names cp1251',$connect);
if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid' LIMIT
5";
$result1=mysql_query($query1);
while($r = mysql_fetch_array($result1)) {
extract($r);
$text2 = nl2br("$text");
echo "$izpulnitel - $pesen<br><br><br><br>$text2";
}
}
else {
$query = "SELECT * FROM `lyrics` ORDER BY id DESC LIMIT
5";
$result=mysql_query($query);
while($r = mysql_fetch_array($result)) {
extract($r);
echo "<a href='view.php?id=$id'>$izpulnitel - $pesen</a><br>";
}
}
?>
