Wrap a table

[jlvollmer]

With PHP 4 and MySQL, i am wanting to retrieve all the records in a table (which is 130 records). Instead of the result table being one long continuous table that wouldn't fit on one piece of paper when printed from Internet Explorer, how can I make it continue in a second column so the table will fit on one printed sheet of paper?

[gothic]

Wow, this could be interesting.. =]

Here's one solution, though maybe not the best.

Create a single table, and load up TR's and TD's and yada yada yada with X amount of data, until it reaches the bottom of the page.

Create a second table right next to the first table, and load that up with data much like you did with the first.

I guess the code could look something like:

table
tr
td
table (First dataset)
all your data
/table
/td
td
table (Second dataset)
all your data
/table
/td
/tr
/table


How does that sound? :P It may work...I don't do HTML too much though..

[ChoaticWhisper]

Ok I think I know what your doing, Ive done something like that before. This is the example that someone gave me, It may make sense to you but if not PM me and Ill find my code that I got working.

You have to know how to work with tables, But basicly what it does it takes the number of rows returned and divides it in half then prints </td></tr><tr><td>.

PHP Code:

$middle = ceil(mysql_num_rows($result) / 2); 

for( $i = 0; $row = mysql_fetch_array($result); $i++ ) 
{ 
// Echo Your Data Here

if( $i == $middle ) echo "</td></tr><tr><td>"; 
}