nested repeat region with pagination

[nested repeat region]

Hello, I'm developing a website that show photos that displays in columns and rows. And for that, I followed a tutorial on nested repeat region - http://www.finalwebsites.com/snippets.php?id=30

It works exactly the way I wanted. Of course I tweak the codes here and there.But now I'm wondering how to add next and previous button to navigate the record. I'm new to PHP. I'm hoping that anyone could help on the continuation of the code I've tried. Help me please anyone?

Hi and welcome at webdigity!

please post your current working code

[Here is the top part of the code]

Thanks! That was fast.  I'm using Dreamweaver to code this. In Dreamweaver, for the record to show, it will  need a record name. And my record name is Recordset1. That's why you can see that every action that has '$', there's '_Recordset1'. I'm not sure if that's how it works. But it works when I did that  I assume it is equivalent to &result. I'm new in this. Anyway

Here is the top part of the code

<?php require_once('Connections/photo.php'); ?>

<?php
$currentPage = $_SERVER["PHP_SELF"];

mysql_select_db($database_photo, $photo);
$query_Recordset1 = "SELECT image FROM class ORDER BY id";
$Recordset1 = mysql_query($query_Recordset1, $gift) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$num_cols_Recordset1 = 2; // the number of columns
$num_rows_Recordset1 = 3; // the number of rows
$num_Recordset1 = 0; // don't change this value, this is the first number of each record inside a record set

?>


And here is where  it displays my record

<?php
                      echo "<table>\n";

for ($rows = 0; $rows < $num_rows_Recordset1; $rows++) {
    echo "<tr>\n";
   
    for ($cols = 0; $cols < $num_cols_Recordset1; $cols++) {
        if ($num < $totalRows_Recordset1) {
            $titel = mysql_result($Recordset1, $num, "id");
            $description = mysql_result($Recordset1, $num, "image");
            $url = mysql_result($Recordset1, $num, "name");
            echo "<td><b>".$titel."</b><br><img src=".$description."><br><i><a href=\"".$url."\">Click Here</a></i><td>\n";
        } else {
            echo "<td>:*</td>\n";
        }
        $num++;
    }
    echo "</tr>\n";
}
echo "</table>\n";
?>


_______________________

Thanks Again 

just checked the navigation function again (I wrote a year ago)

whats your problem? do you tried the example with the code above?

$sql_limit = (isset($_GET['limit'])) ? $_GET['limit'] : 0;
echo navigation_links($sql_limit, $totalRows_Recordset1, 10);


?>

just checked the navigation function again (I wrote a year ago)

whats your problem? do you tried the example with the code above?

$sql_limit = (isset($_GET['limit'])) ? $_GET['limit'] : 0;
echo navigation_links($sql_limit, $totalRows_Recordset1, 10);


?>

you need to use the same limit value in your sql statement

you can try also the more advanced pagination class:
http://www.finalwebsites.com/snippets.php?id=29

Okay. Here's my problem. I have code where it sets the record to display in row and columns. I.e :

1 2
3 4
5 6

Which is this code :

<?php require_once('Connections/photo.php'); ?>

<?php
$currentPage = $_SERVER["PHP_SELF"];

mysql_select_db($database_photo, $photo);
$query_Recordset1 = "SELECT image FROM class ORDER BY id";
$Recordset1 = mysql_query($query_Recordset1, $gift) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$num_cols_Recordset1 = 2; // the number of columns
$num_rows_Recordset1 = 3; // the number of rows
$num_Recordset1 = 0; // don't change this value, this is the first number of each record inside a record set

?>

And with that the record displays as

1 2
3 4
5 6

But now how do I place a link (next/previous) so it shows 7 to12? I've tried the $max_rows but I don't know how to make it work with to the code above

check the limit keyword from the mysql manual...

SELECT * FROM tbl LIMIT 5,10; 

to Retrieve rows 6-15

replace the first value with the variable $sql_limit

[Guest]

[62.885]

Googlebot, Yahoo crawler