// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max1 = $_GET['max'];
if(is_numeric($_GET['start'])) $start1 = $_GET['start'];
if (empty($max1)) $max1 = 1; // $max is the maximum number of results per page
if (empty($start1)) $start1 = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end1 = $start1 + $max1; // This is for the query, gives the number for the LIMIT
$prev1 = $start1 - $max1; // This number is for $start in the Previous-hyperlink
$next1 = $end1; // This number is for $start in the Next-hyperlink
// Select everything from the table
$sql = "SELECT * FROM pagina WHERE frame = 1 ORDER BY id DESC LIMIT $start1, $max1";
// Number of rows from $query
$query75 = mysql_query($sql);
$num = mysql_num_rows($query75) or die(mysql_error());
if (empty($num))
{
$result1 = ("
There are no results.
");
}
else
{
while ($result = mysql_fetch_row($query75))
{
// Show the results
$result1= ("[$result[0]] $result[1]
\n");
}
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev1 >= '0')
{
$volgende1 = ("
volgende week >");
} else {
$volgende1 = ("volgende week >");
}
// Count how many rows there are in the table
$count1 = mysql_fetch_row(mysql_query("SELECT count(*) FROM pagina WHERE frame = 1"));
// Calculate on which page we are
$thispage1 = ceil($start1/$max1+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count1[0] > $max1)
{
// Calculate the amount of pages
$total1 = ceil($count1[0]/$max1);
for($i1=0;$i1<$total1;$i1++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number1 = $i1+1;
// $start has to be $i * $max
$start1 = $i1*$max1;
// If thispage is equal to the number, the link has to be bold
if ($thispage1 == $number1)
{
$result1= ("
" . $number . "");
} else {
$result1= ("
" . $number . "");
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count1[0] > $next1)
{
$vorige1 = ("
< vorige week");
} else {
$vorige1 = ("< vorige week");
}
}
?>
echo $vorige1; ?> |
echo $volgende1; ?> |
|
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Select everything from the table
$sql1 = "SELECT * FROM pagina WHERE frame = 2 ORDER BY id DESC LIMIT $start, $max";
$queryResource = mysql_query($sql1);
while ($row = @mysql_fetch_array($queryResource)) {
?>
Week echo $row['week']; ?>
echo $row['titel']; ?>
echo $row['inhoud']; ?>
} ?> |
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Select everything from the table
$sql1 = "SELECT * FROM pagina WHERE frame = 3 ORDER BY id DESC LIMIT $start, $max";
$queryResource = mysql_query($sql1);
while ($row = @mysql_fetch_array($queryResource)) {
?>
Week echo $row['week']; ?>
echo $row['titel']; ?>
echo $row['inhoud']; ?>
} ?> |
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Select everything from the table
$sql1 = "SELECT * FROM pagina WHERE frame = 2 ORDER BY id DESC LIMIT $start, $max";
$queryResource = mysql_query($sql1);
while ($row = @mysql_fetch_array($queryResource)) {
?>
echo $row['categorie']; ?>
GROEP echo $row['groep']; ?> } ?>
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Select everything from the table
$sql1 = "SELECT * FROM pagina WHERE frame = 3 ORDER BY id DESC LIMIT $start, $max";
$queryResource = mysql_query($sql1);
while ($row = @mysql_fetch_array($queryResource)) {
?>
echo $row['categorie']; ?>
GROEP echo $row['groep']; ?> } ?>
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max = $_GET['max'];
if(is_numeric($_GET['start'])) $start = $_GET['start'];
if (empty($max)) $max = 1; // $max is the maximum number of results per page
if (empty($start)) $start = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Select everything from the table
$sql1 = "SELECT * FROM pagina WHERE frame = 4 ORDER BY id DESC LIMIT $start, $max";
$queryResource = mysql_query($sql1);
while ($row = @mysql_fetch_array($queryResource)) {
?>
echo $row['categorie']; ?>
GROEP echo $row['groep']; ?> } ?>
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max2 = $_GET['max'];
if(is_numeric($_GET['start'])) $start2 = $_GET['start'];
if (empty($max2)) $max2 = 1; // $max is the maximum number of results per page
if (empty($start2)) $start2 = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end2 = $start2 + $max2; // This is for the query, gives the number for the LIMIT
$prev2 = $start2 - $max2; // This number is for $start in the Previous-hyperlink
$next2 = $end2; // This number is for $start in the Next-hyperlink
// Select everything from the table
$sql = "SELECT * FROM pagina WHERE frame = 2 ORDER BY id DESC LIMIT $start2, $max2";
// Number of rows from $query
$query75 = mysql_query($sql);
$num2 = mysql_num_rows($query75) or die(mysql_error());
if (empty($num2))
{
$result2 = ("
There are no results.
");
}
else
{
while ($result2 = mysql_fetch_row($query75))
{
// Show the results
$result2 = ("[$result[0]] $result[1]
\n");
}
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev2 >= '0')
{
$volgende2 = ("
volgende week >");
} else {
$volgende2 = ("volgende week >");
}
// Count how many rows there are in the table
$count2 = mysql_fetch_row(mysql_query("SELECT count(*) FROM pagina WHERE frame = 2"));
// Calculate on which page we are
$thispage2 = ceil($start2/$max2+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count2[0] > $max)
{
// Calculate the amount of pages
$total2 = ceil($count2[0]/$max2);
for($i2=0;$i2<$total2;$i2++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number2 = $i2+1;
// $start has to be $i * $max
$start2 = $i2*$max;
// If thispage is equal to the number, the link has to be bold
if ($thispage2 == $number2)
{
$result2= ("
" . $number2 . "");
} else {
$result2= ("
" . $number2 . "");
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count2[0] > $next2)
{
$vorige2 = ("
< vorige week");
} else {
$vorige2 = ("< vorige week");
}
}
?>
echo $vorige1; ?> |
echo $volgende1; ?> |
|
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max3 = $_GET['max'];
if(is_numeric($_GET['start'])) $start3 = $_GET['start'];
if (empty($max3)) $max3 = 1; // $max is the maximum number of results per page
if (empty($start3)) $start3 = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end3 = $start3 + $max3; // This is for the query, gives the number for the LIMIT
$prev3 = $start3 - $max3; // This number is for $start in the Previous-hyperlink
$next3 = $end3; // This number is for $start in the Next-hyperlink
// Select everything from the table
$sql = "SELECT * FROM pagina WHERE frame = 2 ORDER BY id DESC LIMIT $start3, $max3";
// Number of rows from $query
$query75 = mysql_query($sql);
$num3 = mysql_num_rows($query75) or die(mysql_error());
if (empty($num3))
{
$result3 = ("
There are no results.
");
}
else
{
while ($result3 = mysql_fetch_row($query75))
{
// Show the results
$result3= ("[$result3[0]] $result3[1]
\n");
}
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev3 >= '0')
{
$volgende3 = ("
volgende week >");
} else {
$volgende3 = ("volgende week >");
}
// Count how many rows there are in the table
$count3 = mysql_fetch_row(mysql_query("SELECT count(*) FROM pagina WHERE frame = 2"));
// Calculate on which page we are
$thispage3 = ceil($start3/$max3+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count3[0] > $max3)
{
// Calculate the amount of pages
$total3 = ceil($count3[0]/$max3);
for($i3=0;$i3<$total3;$i3++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number3 = $i3+1;
// $start has to be $i * $max
$start3 = $i3*$max;
// If thispage is equal to the number, the link has to be bold
if ($thispage3 == $number3)
{
$result3 = ("
" . $number3 . "");
} else {
$result3 = ("
" . $number3 . "");
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count3[0] > $next3)
{
$vorige3 = ("
< vorige week");
} else {
$vorige3 = ("< vorige week");
}
}
?>
echo $vorige3; ?> |
echo $volgende3; ?> |
|
// Connect to the Databaseserver
$connect = mysql_connect('mysql.morgensterren.nl','morgensterren','tanthof');
mysql_select_db('morgensterren',$connect);
// Variables
if(is_numeric($_GET['max'])) $max4 = $_GET['max'];
if(is_numeric($_GET['start'])) $start4 = $_GET['start'];
if (empty($max4)) $max4 = 1; // $max is the maximum number of results per page
if (empty($start4)) $start4 = 0; // This is the number to start the query at the right location [DO NOT EDIT]
// Calculate some stuff
$end4 = $start4 + $max4; // This is for the query, gives the number for the LIMIT
$prev4 = $start4 - $max4; // This number is for $start in the Previous-hyperlink
$next4 = $end4; // This number is for $start in the Next-hyperlink
// Select everything from the table
$sql = "SELECT * FROM pagina WHERE frame = 4 ORDER BY id DESC LIMIT $start4, $max4";
// Number of rows from $query
$query75 = mysql_query($sql);
$num4 = mysql_num_rows($query75) or die(mysql_error());
if (empty($num4))
{
$result4 = ("
There are no results.
");
}
else
{
while ($result4 = mysql_fetch_row($query75))
{
// Show the results
$result4= ("[$result4[0]] $result4[1]
\n");
}
// Check if $prev is higher than or equal to 0, if so add the Previous-hyperlink
if ($prev4 >= '0')
{
$volgende4 = ("
volgende week >");
} else {
$volgende4 = ("volgende week >");
}
// Count how many rows there are in the table
$count4 = mysql_fetch_row(mysql_query("SELECT count(*) FROM pagina WHERE frame = 4"));
// Calculate on which page we are
$thispage4 = ceil($start4/$max4+1);
// If $count[0] is higher than $max, show the pagenumbers
if ($count4[0] > $max4)
{
// Calculate the amount of pages
$total4 = ceil($count4[0]/$max4);
for($i4=0;$i4<$total4;$i4++)
{
// The number to show has to be $1+1 (because $i starts with 0)
$number4 = $i4+1;
// $start has to be $i * $max
$start4 = $i4*$max4;
// If thispage is equal to the number, the link has to be bold
if ($thispage4 == $number4)
{
$result4 = ("
" . $number4 . "");
} else {
$result4 = ("
" . $number4 . "");
}
}
}
// If $count[0] is higher than $next, show the hyperlink
if ($count4[0] > $next4)
{
$vorige4 = ("
< vorige week");
} else {
$vorige4 = ("< vorige week");
}
}
?>
echo $vorige4; ?> |
echo $volgende4; ?> |
|