DB question

matik · #1 (**permalink**) 02-27-07, 13:47

Hi!

I have a table.. Structure is:

PHP Code:


			
-- 

-- Table structure for table `database`

-- 



CREATE TABLE `database` (

  `ID` varchar(255) default NULL,

  `Quote` varchar(255) default NULL,

  `Name` varchar(255) default NULL,

  KEY `Name` (`Name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

And for example few entries..

PHP Code:


			
INSERT INTO `database` VALUES ('12714', '"Do what thou wilt" shall be the whole of the law.', 'Aleister Crowley');

I'm using this code, to call my database values into my site.

PHP Code:


			
$result = mysql_query("SELECT * FROM database ORDER BY ID") 

or die(mysql_error());  



echo "<table border='0'>";

echo "<tr> <th>ID</th> <th>Quote</th> <th>Author</th> </tr>";



while($row = mysql_fetch_array( $result )) {



    echo "<tr><td>"; 

    echo $row['ID'];

    echo "</td><td>"; 

    echo "<cite>".$row['Quote']."</cite>";

    echo "</td><td>"; 

    echo $row['Name'];

    echo "</td></tr>"; 

}

It throws me all entries in one page.. Can i have for example 10 entries in one page, and 10 in the other & so on...

thanks in advance

healdem · #2 (**permalink**) 02-27-07, 16:28

as you are using PHPyou could use a prewritten class..... have a look at phpclasses I think there is a paging class there

if that isnt suitable then you need to roll your own function that calls the page recursively with a page or record number and the same search parameters

you then extract the records you want using the limit function
say if you displayed 20 records per page, and you want to display page 5 then you need the first 100 records, you bin records 1..80, and display 81..100

HTH

Internet Services

Web Development

Digital Marketing

Consumer Tech