<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db password";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
$select = mysql_query("SELECT * FROM friends ORDER BY RAND() LIMIT 1
")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$link = mysql_result($select, $i, "link");
$img = mysql_result($select, $i, "img");
echo '<a href="' . $link . '"><img src="' . $img . '" border="0" width="468" height="60"></a><br />';
}
mysql_close();
?>
