Hey guys

First off, I'm a php rookie, so go easy!

Basically, what I'm trying to do is this....

1. Call on a query with several hundred records.
2. Display 2 of these fields (FirstName & LastName) for each record
3. Use PHP to create a new row for every 6 records until all records are done

So the finished product will be a table with all of the people's names - with 6 columns, and many rows (record 1 in the first column, record 2 in the second column, 3 in the third etc).

I know how to call my database, perform the query I want to pull the information from. I just don't know how to set up this loop.

I need the PHP to basically say:

- while there are still records, perform this task
- for each 6 records, create a cell with first and last name in it, then move to the next line and start creating a new row with the next 6 records.

Thanks for any help you can lend me guys!!

Not sure I got this. Do you mean something like this? (FN = First Name, LN = Last Name)

You pull these records

1: FN1, LN1
2: FN2, LN2
3: FN3, LN3
4: FN4, LN4
5: FN5, LN5
6: FN6, LN6
7: FN7, LN7
8: FN8, LN8
9: FN9, LN9
10: FN10, LN10
11: FN11, LN11
12: FN12, LN12
...

And you want to create a new table(?) with these?

1: FN1 + LN1, FN2 + LN2, FN3 + LN3, FN4 + LN4, FN5 + LN5, FN6 + LN6
2: FN7 + LN7, FN8 + LN8, FN9 + LN9, FN10 + LN10, FN11 + LN11, FN12 + LN12
...

Originally Posted by lizciz

Not sure I got this. Do you mean something like this? (FN = First Name, LN = Last Name)

You pull these records

1: FN1, LN1
2: FN2, LN2
3: FN3, LN3
4: FN4, LN4
5: FN5, LN5
6: FN6, LN6
7: FN7, LN7
8: FN8, LN8
9: FN9, LN9
10: FN10, LN10
11: FN11, LN11
12: FN12, LN12
...

And you want to create a new table(?) with these?

1: FN1 + LN1, FN2 + LN2, FN3 + LN3, FN4 + LN4, FN5 + LN5, FN6 + LN6
2: FN7 + LN7, FN8 + LN8, FN9 + LN9, FN10 + LN10, FN11 + LN11, FN12 + LN12
...

Nah, Like this....

John Smith | Andrew Stevens | Jason Taylor
Andrea Moore | David Jones | Donald Johnson

so names move horizontally with a cell for each (above I've only done 3 wide, I want 6).

This is really about CSS as its about presenting your data.

Its a list of names so semantically you should be using <ul><li>FN LN</li></ul>. Then use a class to style the tags. 'Wide' would style the <ul> and 'list' the <li> tag. Result is a row of 6 records.

<style type="text/css">
<!--
.wide{
width:1200px;
}
.list{
width:199px;
float:left;
border-right:1px solid #000;
list-style:none;
}
-->
</style>

Originally Posted by maxxximus

This is really about CSS as its about presenting your data.

Its a list of names so semantically you should be using <ul><li>FN LN</li></ul>. Then use a class to style the tags. 'Wide' would style the <ul> and 'list' the <li> tag. Result is a row of 6 records.

<style type="text/css">
<!--
.wide{
width:1200px;
}
.list{
width:199px;
float:left;
border-right:1px solid #000;
list-style:none;
}
-->
</style>

Your php code will look something like this:

PHP Code:

$query = "SELECT firstname,lastname FROM _table"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_row($result)) { 
$array[$row[0]] = $row[1]; 
} 
while(list($key,$value) = each($array)) { 
echo "<ul><li>$key $value</li></ul>";
}