<?
mysql_connect("localhost","****","******");
@mysql_select_db("****") or die( "Не мога да избера БД .");
$query = " SELECT * FROM txtreklam ORDER BY RAND() DESC LIMIT 6";
$result = mysql_query($query) or die('Error, query failed');
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "click.php?id";
$path = $url.$vote;
echo "<table border=1 width=600 align=center>";
echo "<td><center><b>Текстова реклама</b></center></tr>";
echo "<table border=2 width=100 align=center>";
while($row = mysql_fetch_array($result))
{
echo '<td><a href='.$path.'='.$row['id'].'>'.$row['site'].'</a></td>';
}
echo"</table>";
?>