[bob121]

Hello i'm quite good at PHP but this just isnt working for me, Pagination. Please could someone show me how to use it i want the Results to show below spilt up into pages

$select =mysql_query("SELECT * FROM `1` ORDER by `id` WHERE `cat`='Hardware' ");
while ($i = mysql_fetch_object($select)){
echo"<a href=\"view.php?viewid=$i->id\">$i->name</a></p>";

[MMJ]

Whats the error you are getting?

[bob121]

It was something about LIMIT 1 or something i don't know i deleted it in the hope of someone beening able to come up with something on here

[tomdkat]

Please excuse me for asking but this doesn't look right:

while ($i = mysql_fetch_object($select)){
echo"<a href=\"view.php?viewid=$i->id\">$i->name</a></p>";

That looks like for each iteration of the loop, you're closing a paragraph element (the </p>) yet I don't see where the paragraph is being opened. Is this correct/intentional?

Peace...

[bob121]

Oh sorry my mistake i had a </p> on the end

[MMJ]

Try this:

PHP Code:

<?php
$select = mysql_query("SELECT * FROM `1` ORDER BY id WHERE cat = 'Hardware'");
while ($i = mysql_fetch_object($select)) {
echo "<a href='view.php?viewid=$i->id'>$i->name</a>";
}
?>

If that doesn't work than post the exact error you are getting, PHP or SQL.

[bob121]

That code is ok, i am wanting the same code but so it puts the results into pages

[tomdkat]

Something like this: (pseudo-code)

<?php
$select = mysql_query("SELECT * FROM `1` ORDER BY id WHERE cat = 'Hardware'");
while ($i = mysql_fetch_object($select)) {
// Generate a HTML page here
}
?>

Peace...

[bob121]

I dont think you get me

I want them Results what would be generated by that script put into PAGES so like a pagination script ...

[tomdkat]

So, then something like this:

<?php
$select = mysql_query("SELECT * FROM `1` ORDER BY id WHERE cat = 'Hardware'");
while ($i = mysql_fetch_object($select)) {
// if page-break threshold is reached
//   kick out a page break and start a new page
// process current row in result set
}
?>

Of course, I'm not sure what your definition of a "page" is (HTML page, page in a document that will be generated, something else entirely) but the above algorithm might do what you want.

Peace...

[bob121]

That does not put the results into pages . . .

[MMJ]

Originally Posted by bob121

That does not put the results into pages . . .

Oh, ok.

http://www.google.com/search?q=pagination+php