Previous and Next Buttons / Query

[marsupillami]

Hi, I´m splitting a query in pages with 15 rows per page. But I can´t make it work. here´s how I´m doing it:

	$max_rows = 15;
	if(!$start)
	$start = 1;

$sql = "SELECT sid, catid, aid, title, time, hometext, bodytext, counter, topic, informant, notes FROM ".$prefix."_stories $qdb ORDER BY sid DESC LIMIT $start, $max_rows";

and then, the button with Next Results:

$start = $start + $max_rows;
print("<FORM action=\"index.php\" method=\"post\">\n");
print("<INPUT TYPE=\"hidden\" name=\"start\" value=$start>\n");
print("<INPUT TYPE=\"submit\" value=\"Próximas $max_rows notícias\">\n");
print("</FORM>\n");

Anybody Could Help me?

Also, How can I put numbered pages, instead of next and previous? Like this: 1 | 2 | 3 | 4 | 5 .... till last pasge.

Thank you

[cassius]

Try reading the FAQ at the coding-froum:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10234923

They have a recipe for pagination that I think is quite good.

[marsupillami]

Works perfectly. Thank you

[marsupillami]

Ok, I have it almost done. Just have on final problem:

I want to put to IF´s:

if ($row->activar == "on")
if ($row->plataforma == "AMD")
{

And I think it shoul be done right here:

$results = mysql_query("SELECT * FROM wcpuid ORDER BY $order DESC LIMIT $page, $limit"); //defines the query parameters 

for($i = 0; $i < $limit; $i++){ 
 for ($count = 1; $row = mysql_fetch_assoc ($results);++$count) 



  $printthis = "....

But it doesn´t work 🙁 All I get is a blank screen.

Can anybody help to find the error?

Thank you

[TTT]

didn't really get that, but first of all

//for ($count = 1; $row = mysql_fetch_assoc ($results);++$count)

=>
$arr= mysql_fetch_assoc ($results);
$len = count($arr);
for ($count = 1; $count<=$len;$count++)

... i usually support fetch_row method:

$q = SELECT id,some,field FROM table where 1=1 ORDER BY id ASC

while($foo = mysql_fetch_row($q)) {
if($foo[1] == "da") {
if($foo[2] == "blaah") {
echo $foo[0];
}
}

}

[marsupillami]

I didn´t understand very well what to do, bu here´s what I did:

$results = mysql_query("SELECT * FROM wcpuid ORDER BY $order DESC LIMIT $page, $limit"); //defines the query parameters 

for($i = 0; $i < $limit; $i++){ 
// for ($count = 1; $row = mysql_fetch_assoc ($results);++$count) {

$arr= mysql_fetch_assoc ($results); 
$len = count($arr); 
for ($count = 1; $count<=$len;$count++) 

$q = SELECT id,activar,plataforma FROM table where 1=1 ORDER BY id ASC 

while($foo = mysql_fetch_row($q)) { 
if($foo[activar] == "on") { 
if($foo[plataforma] == "AMD") { 

  $printthis = "

Error: Parse error: parse error in /home/oc-zone/public_html/modules/Database/amddb.php on line 129

Thank you

[marsupillami]

Any help, please?