Need help/w Page: 1,2,3,4 function!

Posted on 16th Feb 2014 07:03 pm by admin

So I have this code im working on where it's ment to display seperate pages having 20 logs each
I'm having SOOOOOOOOO much trouble with it... it's supposed to work! >,<

I get the right amount of Pages 1,2,3,4, but when I click on them it doesn't show up right =(

http://www.clan-wd.com/test.php


<?php
include "config.php";



if($page == NULL) {
$page = 0;
} else {
$page = $page - 1;
}
global $myrow;
extract($myrow);


if($p == "") {

echo "<table width='100%' border='3'>";

// Counting Codes #########
$result = @mysql_query("SELECT COUNT(*) FROM logs");
$count = mysql_fetch_array($result);
$count = $count[0];

$num_pages = ($count / 20) + 1;
$limit = 20 + $startNum * 20;
$i = 0;


$result = @mysql_query("SELECT * FROM logs ORDER BY id DESC");
while(($row = mysql_fetch_array($result)) && $i <= $limit) {
extract($row);

if($i >= ($startNum * 20)) {
echo "
<tr><td><b>$id - $logName</b> $date</td></tr>
";
}
$i++;
}
echo "
</table>
<p align=left><b>Page:</b>
";
for($i = 1; $i <= $num_pages; $i++) {
echo "<a href=test.php?page=$i>$i</a>";
}

}


?>

Your Answer:

Login to answer

Other forums

Unable to display contents in Second Drop Down Box
Hi All,

What I am trying to do is 2 dependent drop down boxes and when user selects su

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
What are causes of a connection-timeout with fopen()? 
Hello! Here is the situation: The server I host my website on just upgraded it's PHP build from 4.4.
Ariba 9r - SAP MM Integration     
Hi experts,



The standard Ariba adapter for 9r creates a relationship between Cost Centers
Firefox displaying PHP source code?? 
Currently testing a site thats almost built, am going to be including php on a sidebar on all pages 
Help: problem with Headers to download PDF file 
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op
Variable uses and placement  
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do
Why is this query failing? 
Why is this not working?
$query = "SELECT *  FROM `users` WHERE `userid` = " . $USERID 
This is driving me nuts! 
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo