Only 6 records at a time

[Anon]

I want to show not more than 6 records at a time
in this fashion

1 2 3

4 5 6

How do I do it?

[Anon]

For showing x number of records at a time, you can check http://php.socket7.net for a script called Improved Next/Prev Buttons.

It can't help you with the layout, though I'm sure a simple HTML will do nicely.

[Anon]

I used this code to display a certain number of records per row, this will only work for your situation if you want to have more than 2 rows of 3 each it will take some tweaking but send me an email and I can help you with that as well:

$result = mysql_query("SELECT fieldname from tablename LIMIT 0, 6", $db);
$i = 1;
print '<table border=1><tr>';
while ($row = mysql_fetch_array($result)) {
if ($i == 3) {
printf('<td>%s</td></tr><tr>', $row["fieldname"]);
}
else {
printf('<td>%s</td>', $row["fieldname"]);
}
$i++;
}
print '</tr></table>';