dividing data into columns

[freemancomputer]

I have a list of data from my database that is listed via php into one column, this fits my needs for right now. How ever I will shortly this will make the web page to long. I am looking for a simple way to take what I have now and once it reaches 20 entry's to start listing it into another column, and then after 40 are listed it would create a new page.

Thanks in advance

This is what I have that lists everything in one column.

    <?php
include"scripts/connect.php" ;

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM movies WHERE type LIKE 'movie' ORDER BY title";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table width="80%" align="left">
<tr>
<td>Movies </td>
</tr>  
<?php
$i=0;
while ($i < $num) {

$title=mysql_result($result,$i,"title");

?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><a href=/rules.php?title=<? echo urlencode($title); ?>><?php echo $title; ?></a></font></td>

</tr>


<?php
$i++;
}
?>
</table>
</div>

[felgall]

To add an extra column means you'd need to store the first 20 before outputting anything so that you can output entry 21 alongside entry 1 and so on.

It would be easier if the data goes across rather than down because then you just remove the </tr><tr> after the odd numbered entries.

Adding processing for multiple pages means that you need to pass the current position between pages and then amend your database query to use that start position as the OFFSET and get just the next 40 entries using LIMIT 40.