Returning Results in a tabulated format?

furious5

I am currently contemplating how I would execute the following.

I am wanting to return all the records in a column from a table and format this in to 4 columns.

Obviously the PHP I would be using is this:

<?php

//SQL query
$sql = "SELECT industry FROM industry";
$sql_result = mysql_query($sql, $connection);
while ($row = mysql_fetch_array($sql_result)){
$industry = $row["industry"];
$ret_industry = urlencode($industry);

echo $industry;
echo "<input type=checkbox name=industry value=$ret_industry>";

}
?>

And the HTML would be this:

<table>
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
</table>

But how do I go about returning all the records, dividing them by 4 and then dynamically placing them in a table? 😕

dinger

have a variable called $count.

Set it to 0 before you loop through your results.

Each time through the results, check it.

If it is 0, print the opening table and tr tags then the < td > your data < / td >

If it is one or two simply print your data with the td tags.

If it is 3, print the data then your closing < /tr > and < /table > tags.

After checking it and printing the data, add 1. It it 3 set it back to 0.

This can also be helpful for printing rows in alternating colors.

Chris

Weedpacket

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10243429&highlight=table+columns
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10240966&highlight=table+four+columns

furious5

Thanks for that.

I just need to work out how to get the colums organised in alphabetical order rather than alphabetically across the screen.