Make a different sized table depending on the ammount of data that is received

the_mysox1

how can i make a different sized table depending on the data that is receved froma database.

so for example if there is 1-5 rows returned it will show only 1 row in my html table but then if there is 6-10 rows returnd from the database it will show 2 rows in my html table and so on.

I have really no idea what I should be doing some advice would be much appriecieated.

Bonesnap

When you pull the data from the database, use a loop to iterate through each record. During each iteration, print the necessary <tr><td></td></tr> tags and populate them with the data retrieved.

<?php
$result = mysql_query("SELECT * FROM users");
while($row = mysql_fetch_array($result))
{
	//This is where your <tr><td></td></tr> tags will go
}
?>

the_mysox1

i know how to do that but what if i want only to show 5 results per line? and if i only want it to show 5 lines then add a scroll bar etc.

Bonesnap

I don't quite understand what you're trying to achieve. You said if it returns 1-5 rows, only display 1. So why bother with the other 4 rows? Or 6-10 rows only display 2 rows. Again, why even bother with retrieving that many rows?

EDIT: Are you trying to display up to 5 rows at a time? If that's the case, then utilize the LIMIT clause on your query. Every time you want to view the next 5 rows, you'll have to recall your query, but this time the values used in the LIMIT clause will be different, retrieving different records.

If that's not what you're looking for then I really don't know.

the_mysox1

ok what i want is for it to display 5 rows retrieved from the db in one html table row then the next 5 rows from the db displayed in a second html table row.

so for records 1-5 they will be in the first <tr></tr> then the next 5 records returned will be in the next <tr></tr> etc.