<?
session_start();
include("database.php");
include("onlinecheck.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<!-- Minus AutoDato -->
<title>MUSIKVIDEN.DK -DIN GUIDE TIL MUSIKKEN!</title>
<META NAME="Generator" CONTENT="Stone's WebWriter 3.5">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="
http://www.musikviden.dk/test/style.css"><style type="text/css">body {
background-image: URL(cell_head_bg.gif);
background-repeat: no-repeat;
background-attachment: fixed;
background-position: bottom;
}
</style>
</head>
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" bgcolor="#F5FBFF" style="font-family: Verdana">
<table width="705" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="5" align="center"><?php include("
http://www.musikviden.dk/test/top.php"); ?></td>
</tr>
<TR>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="
http://www.musikviden.dk/test/billeder/main_celle_bg.gif"><tr>
<td width="10" border="0"></td>
<td valign="top" width="131" border="0"><?php include("
http://www.musikviden.dk/test/left.php"); ?></td>
<td valign="top" width="423" topmargin="0" align="middle">
<BR>
<table border="0" width="358" height="26" cellpadding="0" cellspacing="0">
<TR>
<td width="358" height="26" background="../billeder/overs_tile.jpg"><font face="tahoma" size="2"><B> Søgeresultat</B></font></td>
</TR>
</table>
<BR>
<?php
if(isset($sog)){
if(empty($sog)){ echo "Du skal indtaste et søgeord";} else {
$db = mysql_connect("xxx", "xxx", "xxx");
mysql_select_db("musikvidendk", $db);
$limit=8;
$numresults=mysql_query("SELECT id, dato, billede, overskrift, skribent, tekst, teaser FROM nyheder where overskrift like '%$search%' or tekst like '%$sog%' or teaser like '%$sog%' order by id desc ");
$numrows=mysql_num_rows($numresults);
if($numrows == 0){
echo "Ingen resultater af din søgning";
} else {
if (empty($offset)) {
$offset=0;
}
$query = mysql_query("SELECT id, dato, billede, overskrift, skribent, tekst, teaser FROM nyheder WHERE overskrift like '%$sog%' or tekst like '%$sog%' or teaser like '%$sog%' order by id desc LIMIT $offset,$limit") or die(mysql_error());
while($data = mysql_fetch_array($foresp)){
?>
<table border="0" width="300" cellpadding="0" cellspacing="0">
<TR>
<td rowspan="3" width="70" height="70"><a href="
http://www.musikviden.dk/test/undersider/musiknyhed.php?id=<? echo $data[0]; ?>"><IMG SRC="../../billede/<? echo $data[2]; ?>" style="border: 1px #000000 solid;" WIDTH="70" height="70" ALT=""></a></td>
<td width="230" height="23"><font face="tahoma" size="1"> <B><?php echo "$data[3]"; ?></B></td>
</TR>
<TR>
<td width="230" height="24"><font face="tahoma" size="1"> <a href="
http://www.musikviden.dk/test/undersider/musiknyhed.php?id=<? echo $data[0]; ?>"><B>Læs...</B></a></td>
</TR>
</TR>
<td width="230" height="23"><font face="tahoma" size="1"> Lagt online d. <? echo date("j/n - Y", $data[1]); ?>.</font></td>
</TR>
</table>
<table border="0" width="358" height="26" cellpadding="0" cellspacing="0">
<TR>
<td width="358" height="35"></td>
<TR>
</table>
<?php }
$pages=intval($numrows/$limit);
if ($numrows%$limit) {
$pages++;
}
echo "<center>Side " ;
for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
if ($offset==$newoffset) {
echo ("<font color=\"#800080\"><b>$i</b></font>\n");
} else {
echo "<a href=\"".$PHP_SELF."?offset=$newoffset\">$i</a>\n";
}
}
echo "\n</center>\n";
}
}
}
?>
<br><br>
<TABLE Border="0" width="400">
<TR>
<td align="center">
<table width="300" border="0" cellpadding="0" cellspacing="0">
<TR>
<td align="center">
<font face="verdana" SIZE="2">Søg igen...</font>
</td>
</TR>
</table>
</td>
</TR>
<tr>
<TD Align="center" colspan="2">
<Form method=post action="../phpsendt/nresultat.php">
<input type=text name=sog size="25" class="email"><BR>
<font size="2"><B>------<B></font><BR>
<input type=submit Class="submitknap" value="Søg">
</form>
</td>
</TR>
</table>
</td>
<td valign="top" width="131" border="0"><?php include("
http://www.musikviden.dk/test/right.php"); ?></td>
<td width="10" border="0"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5" align="center"><?php include("
http://www.musikviden.dk/test/partnerbund.php"); ?></td>
</tr>
<tr>
<td align="center"><?php include("
http://www.musikviden.dk/test/bund.php"); ?></td>
</tr>
<tr>
<td height="20">
</td>
</tr>
</table>
</body>
</html>