[Resolved] formating the results on a webpage better

[redirish]

Hello one and all,

**//'$initial' is a letter of the alphabet got from the previous script

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

<?php
mysql_select_db($database_surname, $seaman);
$query_Recordset1 = "SELECT surname.surname
FROM surname
WHERE left(surname.surname,1)='$initial'
GROUP BY surname.surname
ORDER BY surname.surname";

$Recordset1 = mysql_query($query_Recordset1, $seaman) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<?php do { ?>

<a href="details.php?surname=<?php print $row_Recordset1['surname']; ?>"

<?php echo $row_Recordset1['surname']; ?>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

<?php mysql_free_result($Recordset1); ?>

I know this can be written as one <?php-?> but it make life easier while testing.

The above script works but as I have 12000 names of sailors that died in the Great War it makes very long single list of the letter "M" names. You have to scroll down for ever.

How do I make it spread over the page in rows of 4 or 5 and stop when 60 names are visiable and then continue to the next page.

Can I do it using PHP or do I have to use HTML?

All idea's are welcome.

greetings from The Netherlands

Liam

[mrhappiness]

first you have to do SELECT COUNT(surname) do count how many entries there are

then you have to extend your SELECT with a LIMIT clause
LIMIT 60 or LIMIT 0,60 for the first 60 entries (0 - 59)
LIMIT 60,60 for entries 60 - 119
LIMIT 120,60 for entries 120 - 179
...

the first part of the limit is calculated as follows

$_GET['page'] = empty($_GET['page']) ? 1 : (int)$_GET['page'];
$_GET['page'] = max(1, $_GET['page'];
$limit = ($_GET['page'] - 1) * 60;

hth

[redirish]

Thanks for another building brick.

I will test at home tonight.

If I understand correctly this will limit the number of surnames sent to a page, click a button and then the next 60 appear.

Anybody know what I need to use to spread it out so I only use 15 or 10 rows instead of 60 rows.

Liam

[mrhappiness]

http://dev.mysql.com/doc/mysql/en/select.html knows 😉

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants.

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15

[redirish]

Thanks for explaining it and for the link.

I can work from examples but get lost when reading explainations.

Liam