Displaying paged results in a table

[hsmom314]

I have used the LIMIT clause to display pagination results on different pages. I would like to display my query results on a single page in a table with a maximum of 3 columns. Some queries would use only 1 column while others would use 2 or all 3 columns. Is this possible? Any info on how to accomplish this would be greatly appreciated.

Thanks,

Deb

[Rodney_H_]

Well since you didn't supply a whole lot of specific information, Deb, I can only give you a somewhat theoretical reply: Yes. It can be done, and one (of many) possible way(s) to achieve this:

<?php
$fields =  array(); // would be one, two, or three fields.

$query = "SELECT " . implode(',', $fields) . " FROM table LIMIT " . $start . ',' . $limit;

$result = mysql_query($query) or exit(mysql_error());

if(mysql_num_rows($result) == 0) exit('nothing here...');

?>
<table>
<?php
while($row = mysql_fetch_array($result))
{
	?>
	<tr>
		<?php
		foreach($fields as $value)
		{
			?>
			<td><?php echo htmlspecialchars($row[$value]); ?></td>
			<?php
		}
		?>
	</tr>
	<?php
}
?>
</table>

[hsmom314]

The table should not exceed 3 columns nor exceed 15 rows. The data in the database fits within this criteria. I would like for the records to display as follows:

Record 1 Record 16 Record 31
Record 2 Record 17 Record 32
Record 3 Record 18 Record 33
" " "

Record 15 Record 30 Record 45

If only 10 records are returned, the data would all fit in the first column.

Hope this helps.

Thanks,

Deb