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

Material Master Update through BAPI - Follow up material not updated
Hi Experts,

I am updating the material master through a custom transaction using the BAPI

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

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

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al