Последни пет добавени текста ?

[ReXTaN]

Как мога да направя че в началната страницата да изкарва последните пет добавени текста? С тая система съм:
http://web-tourist.net/login/login/view.php?st=2210

+1 на тоя който ми помогне

Накратко: Искам да изкарам на главната страница последните пет добавени текста

 

[advokata]

<?PHP
$sql = "SELECT * FROM lyrics LIMIT 0,5";
$query = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_array($query)) {
echo $row["title"]."<br>";
}
?>

Става ли?

 

[AnyB1s]

 $rez = "SELECT * FROM lyrics ORDER BY id DESC LIMIT 5";
$q = mysql_query($rez) or die(mysql_error());
while($row = mysql_fetch_array($q)){
echo "$row[izpulnitel] - $row[pesen] <br />";
}

Така?

 

[ReXTaN]

 $rez = "SELECT * FROM lyrics ORDER BY id DESC LIMIT 5";
$q = mysql_query($rez) or die(mysql_error());
while($row = mysql_fetch_array($q)){
echo "$row[izpulnitel] - $row[pesen] <br />";
}

Така?

Така си бачка но как мога да направя да ми изкарва и на кирилица и като цъкна върху песента да влиза в страницата на текста ?

 

[FestarBG]

$rez = "SELECT * FROM lyrics ORDER BY id DESC LIMIT 5";
$q = mysql_query($rez) or die(mysql_error());
while($row = mysql_fetch_array($q)){
echo "<a href='$row['link_kam_str_s_teksta']'>$row[izpulnitel] - $row[pesen]</a> <br />";
}

А за кирилицата имаш ли <meta http-equiv='Content-Type' content='text/html; charset=windows-1251'>?

 

[AnyB1s]

list.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>Untitled Document</title>
</head>

<body>
<?php
$host = "hosta ti";
$user = "user ti";
$pass = "passa ti";
$db = "db-to ti";
mysql_connect($host,$user,$pass) or die("nema server");
mysql_select_db($db) or die("nema mi db-ti");
$chars = "SET NAMES cp1251";
mysql_query($chars);

$rez = "SELECT * FROM lyrics ORDER BY id DESC LIMIT 5";
$q = mysql_query($rez) or die(mysql_error());
while($row = mysql_fetch_array($q)){
echo "<a href=\"view.php?id=$row[id]\">$row[izpulnitel] - $row[pesen] </a><br />";
}
?>
</body>
</html>

vij.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>Untitled Document</title>
</head>

<body>
<?php
$host = "hosta ti";
$user = "user ti";
$pass = "passa ti";
$db = "db-to ti";
mysql_connect($host,$user,$pass) or die("nema server");
mysql_select_db($db) or die("nema mi db-ti");
$chars = "SET NAMES cp1251";
mysql_query($chars);
$id = $_GET['id'];
$rez = mysql_query("SELECT * FROM lyrics WHERE id = $id");
$tekst = mysql_fetch_array($rez);
echo "$text[izpulnitel] - $text[pesen] <br />" .$tekst['text']. "<p>towa e to</p>";
?>
</body>
</html>

Виж така.