fejl finding
Der er noget i databsen men efter jeg har sat limit på hvor mange resultater den skal vise pr. side virker det ikke mere !------------------------------------
CREATE TABLE `IT` (
`id` int(11) NOT NULL auto_increment,
`overmenu` varchar(255) NOT NULL default '',
`undermenu` varchar(255) NOT NULL default '',
`dato` varchar(255) NOT NULL default '0000-00-00',
`overskrift` varchar(255) NOT NULL default '',
`tekst` longtext NOT NULL,
`forfatter` varchar(255) NOT NULL default '',
`ansvarlig` varchar(255) NOT NULL default '',
`foto` varchar(255) NOT NULL default '',
`kilde` varchar(255) NOT NULL default '',
`kildelink` varchar(255) NOT NULL default '',
`forside` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
------------------------
<? if (!isset($_get['id'])) { ?>
<a href='hent_nyheder.php?id=software'>software</a>
<a href='hent_nyheder.php?id=hardware'>hardware</a>
<?
} else {
include ("connect.php");
$prside = 10;
$start = (isset($_GET['s']) && is_numeric($_GET['s'])) ? $_GET['s'] : 0;
$query = mysql_query("SELECT * FROM IT WHERE undermenu = ".$_GET['id']." ORDER BY dato DESC LIMIT $start, $prside") or die (mysql_error());
while($row = mysql_fetch_array($query)) {
?>
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title></title>
</head>
<body>
<table style="text-align: left; width: 280px; height: 47px;"
border="1" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td><?php echo $row[overskrift]; ?><br>
<?php echo $row[forfatter]; ?> -<?php echo $row[dato]; ?> <br>
<br>
</td>
</tr>
<tr>
<td></td>
</tr>
</tbody>
</table>
</body>
</html>
<?
}
$query = mysql_query("SELECT count(undermenu) AS antal FROM IT");
$antalRows = mysql_result($query,0);
if($start > $prside)
{
$prev = $start - $prside;
echo " <a href=\"?s=$prev\"><< Prev</a>";
}
if(($start+$prside) < $antalRows)
{
$next = $start + $prside;
echo " <a href=\"?s=$next\"Next >></a>";
}
}
?>
