// Connect.php start
// --
<?php
$db = mysql_connect(
\"localhost\",
\"admin\",
\"password\") or die (mysql_error());
mysql_select_db(\"banner\",$db) or die(mysql_error());
?>
// --
// Connect.php stop
// Banner.php start
// --
<HTML>
<BODY>
<?php
srand();
include \"connect.php\";
$result1 = mysql_db_query(\"banner\", \"SELECT COUNT(*) from billeder\");
$antalbilleder=mysql_result($result1,0);
$ting=rand(1,$antalbilleder);
$sql = \"select * from billeder where id=$ting limit 0,1\";
echo $sql; // Kun for at se hvordan min sql sætning ser ud..Debug option ;-)
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res)) {
?>
<a href=\"<?=$row[url];?>\"><?php echo $row[billedetekst]; ?></a>
<?
}
?>
</BODY>
</HTML>
// --
// Banner.php stop
// Database setup start
// --
# phpMyAdmin MySQL-Dump
# version 2.2.1-rc2
#
http://phpwizard.net/phpMyAdmin/#
http://phpmyadmin.sourceforge.net/ (download page)
#
# Vært: localhost
# Genereringstidspunkt: 01/12 2001 kl. 23:16:35
# Server version: 3.23.40
# PHP version: 4.0.6
# Database: : `banner`
# --------------------------------------------------------
#
# Struktur dump for tabellen `billeder`
#
CREATE TABLE billeder (
id tinyint(3) NOT NULL auto_increment,
filename varchar(255) NOT NULL default \'\',
billedetekst varchar(255) NOT NULL default \'\',
url varchar(255) NOT NULL default \'\',
PRIMARY KEY (id)
) TYPE=MyISAM;
// --
// Database setup stop