[Resolved] help with faulty script

[tuf-web_co_uk]

ok this worked with a search engine on my website, but when i try to place the same, pagination into my blogs page, because on some, about 30-40 are being loaded at once, and this will get bigger, and slower for users

it seems to only want to display the first record of the 10 it selects

so instead of a query like
$sql = "SELECT * FROM blogs LIMIT 0,10";

it displays as
$sql = "SELECT FROM blogs LIMIT 0,1";
$sql = "SELECT FROM blogs LIMIT 10,1";
$sql = "SELECT * FROM blogs LIMIT 20,1";

heres the script - clicky

you can see what happens if you click here

thanks... 😉

[siwis]

What happens if you manually replace the variable $limit with the number 10?

[drawmack]

try echoing out your sql to see what it is doing.

[tuf-web_co_uk]

even with the limit set manually it still only displays one record

[siwis]

In which case, I'd assume that the error lies within your while () loop.

To be honest, I'm struggling to get a handle on your code because it has no defined structure or indentation to make following it easy. From what I have been able to work out, I can't find an end to your while() statement, meaning that your script never runs the second and subsequent passes.

Similarly, examining the source code, there is no </body> or </html> tags so the page is incomplete.

Try adding one } to the very end of the script and see what occurs. By my counting you're one short.

Similarly, you have no specific rules for your self as to how you invoke certain statements. On one hand you use:

if(empty($page))  

$page = 1; 

Then you use;

if($numofpages>1){echo" (showing: $from - $to)";}

Try restructuring your coding to follow PEAR rules and you'll find it a lot easier to debug. Certainly it may take slightly longer to code, but the pay-back in bug reduction is massive;

while ($this = mysql_fetch_array($query_result) {
    $value = $this['blah'];
    $another_value = $this['blahblah'];
    if ($numofpages>1) {
        echo " (showing: $from - $to)";
    };
};

[tuf-web_co_uk]

1st off thanks for the hasty replies

2ndly the pagination code isn't mine

3rdly the problem was in a sql statement that ran in the while loop

it used the same variable $result as the while loop did

thanks anyways 🙂