Som det er lige nu - kommer der 10 elever pr side !
Men jeg ville gerne have så der kom 20... altså 10 på 2 rækker!
Lige nu kommer det hele på en lang række !
Her er koden:
<script language="javascript">
function slet(e,id)
{
if (confirm("Er du sikker på at du vil slette !! "))
{
e.href="slet.php?id="+id;
}
}
</script>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<center>TSR Elevarkiv</center>
<center><form action="
http://lortespand/indexseek.php" method="get"><FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="1">
Søg: <input type="text" name="seek"> <input type="submit" name="sog" value="Søg"></FONT></form>
<p><FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="1"> </center>
<?
if ($seek) {
$host = "localhost";
$loginname = "";
$password = "";
$database = "gallery";
mysql_connect("$host", "$loginname", "$password") or die (mysql_error());
mysql_select_db("$database") or die (mysql_error());
$sql = mysql_query("select fname, id from sticker_members where fname like '%$seek%' OR uname LIKE '%$seek%'");
$number = mysql_num_rows($sql);
print "Din søgning på: <b>$seek</b> gav $number resultater";
while ($row = mysql_fetch_array($sql)) {
print "<li><b><a href=\"info.php?id=$row[id]\" target=\"_blank\">$row[fname]</a></b></li>";
}
} elseif ($sog) {
print "Du skrev ikke noget søgeord!!";
} else {
}
?>
<?
include "config.in.php";
$db = mysql_connect($host,$username,$password) or die ("Cannot conet to the database now.");
$sql = "select * from sticker_members order by uname DESC";
$result = mysql_db_query($dbname,$sql) or die ("Kan ikke få forbindelse til TSR elevarkiv databasen!");
$NRow = mysql_num_rows($result);
mysql_connect($host,$username,$password);
$sql = "select id from sticker_members order by uname DESC";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "<p><p><center><span class=text> ".$show_no_mem_cf."</p></center><br><br>\n";
}
$per_page=$per_page_mem_cf;
if (!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$result = mysql_db_query($dbname,$sql);
$num_rows = $NRow ;
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}
$query = "select * from sticker_members order by id DESC LIMIT $page_start, $per_page";
$result = mysql_query($query);
print("<blockquote><span class=text>");
while( $arr = mysql_fetch_row( $result ) )
{
if ( $arr[10] == "1" ) {
$arr[10] = $cat_cf1;
};
if ( $arr[10] == "2" ) {
$arr[10] = $cat_cf2;
};
if ( $arr[10] == "3" ) {
$arr[10] = $cat_cf3;
};
if ( $arr[10] == "4" ) {
$arr[10] = $cat_cf4;
};
if ( $arr[10] == "5" ) {
$arr[10] = $cat_cf5;
};
$num_com = strlen($arr[8]);
if ( $num_com > 70 ) {
$comment_c = substr($arr[8],0,70) . "...";
} else {
$comment_c = $arr[8];
};
print "<table width=\"550\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<p>";
};
print "</p><center><span class=index_show_mem> ";
if ($prev_page) { echo "<B><a href=index.php?ipage=$prev_page>Prev</a> </B>"; };
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo "<a href=index.php?page=$i>$i</a>"; } else { echo " <B><font color=000000>[Side $i] </B> -</font> "; }
};
if ($page != $num_pages) { echo " <B><a href=index.php?page=$next_page> - Next</a></B>" ; } ;
if ($page == 0 ) { echo "" ; } ;
print "</p><p></center>";
?>
<?
include "config.in.php";
$db = mysql_connect($host,$username,$password) or die ("Cannot conet to the database now.");
$sql = "select * from sticker_members order by uname DESC";
$result = mysql_db_query($dbname,$sql) or die ("Cannot command the database now.");
$NRow = mysql_num_rows($result);
mysql_connect($host,$username,$password);
$sql = "select id from sticker_members order by uname DESC";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "<p><p><center><span class=text> ".$show_no_mem_cf."</p></center><br><br>\n";
}
$per_page=$per_page_mem_cf;
if (!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$result = mysql_db_query($dbname,$sql);
$num_rows = $NRow ;
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}
$query = "select * from sticker_members order by uname ASC LIMIT $page_start, $per_page";
$result = mysql_query($query);
print("<blockquote><span class=text>");
while( $arr = mysql_fetch_row( $result ) )
{
if ( $arr[10] == "1" ) {
$arr[10] = $cat_cf1;
};
if ( $arr[10] == "2" ) {
$arr[10] = $cat_cf2;
};
if ( $arr[10] == "3" ) {
$arr[10] = $cat_cf3;
};
if ( $arr[10] == "4" ) {
$arr[10] = $cat_cf4;
};
if ( $arr[10] == "5" ) {
$arr[10] = $cat_cf5;
};
$num_com = strlen($arr[8]);
if ( $num_com > 70 ) {
$comment_c = substr($arr[8],0,70) . "...";
} else {
$comment_c = $arr[8];
};
print "<table width=\"550\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"150\"><a href=info.php?id=$arr[0]><img src=photo/$arr[7] width=80 border=0></a><br></td>
<td width=\"500\"> <span class=text>Navn: $arr[2]<br>
SP nr: $arr[1]<br>
<b><a href=sygemelding.php?id=$arr[0]>Anmeld sygemelding</a></b><br>
<a href='java script:void(0)' onclick='slet(this,$arr[0])'>Slet SP $arr[1]</a>
</td>
</tr>
</table><p>";
};
print "</p><span class=index_show_mem> ";
if ($prev_page) { echo "<B><a href=index.php?ipage=$prev_page>Prev</a> </B>"; };
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo "<a href=index.php?page=$i>$i</a>"; } else { echo " <B><font color=000000>[Side $i] </B> -</font> "; }
};
if ($page != $num_pages) { echo " <B><a href=index.php?page=$next_page> - Next</a></B>" ; } ;
if ($page == 0 ) { echo "" ; } ;
print "</p><p>";
?>