Making dynamic tables

[benson]

Hi,

To be straight to the point.

I want too create (out of an array) an dynamic table.
I have two array and one of them is to be chosen too create an table from. in the array are names.
If there are 8 names i want 8 rows and 2 columns but i there are more then 8 i want 8 rows and 4 columns.

The first and the third column should be 11 wide ande the second and fourth should be autofit.

How can i do this?

(The goal is too have an row of checkboxes that can be ticked and their value should be in the column next too it like:
[] French
[] Dutch
so on)

In advance thanks

[travelbuff]

I see 2 options here:
1. select your data from the db, count the number of elements in the array to establish number of columns and the number of rows in the result to establish the number of rows;

2. the cleaner way, build your table in a while loop. a (long) example from a project I am working on:

   while ($specials_row = mysql_fetch_array($specials_result)) {
   	 $special_title = $specials_row['special_title'];
   	 $booked_b4_date = $specials_row['booked_b4_date'];
   	 $approved = $specials_row['approved'];
   	    //set the status	
   		if ($approved == 0) {
   		$status = 'Awaiting Approval';
   		} elseif ($approved == 1) {
   		$status = 'Active';
   		} else {
   		$status = 'Expired';
   		} //end if -elseif
   	 $num_views = $specials_row['num_views'];
   	 $num_inq = $specials_row['num_inq'];
   	 $resort_name = $specials_row['resort_name'];
   //build the table data cells dynamically
   $display_specials .= <<<dsplyspcls
   	<tr>
                   <td><p><strong>$special_title</strong></p></td>
                   <td><p>$resort_name</p></td>
                   <td><p>$booked_b4_date</p></td>
                   <td><p><strong>$status</strong></p></td>
                   <td><p> $num_views - $num_inq </p> </td>
                 </tr>
   dsplyspcls;
   	 } //end while
   
   //open a table and define a header row
               <table width="95%" border="2">
                 <tr>
                   <td><p><strong>Title</strong></p></td>
                   <td><p><strong>Resort</strong></p></td>
                   <td><p><strong>Must be booked by</strong></p></td>
                   <td><p><strong>Status</strong></p></td>
                   <td> <p> <strong>#Views - #Inquiries </strong></p></td>
                 </tr>
                 <? echo $display_specials ; ?>
               </table>
   

   
   
   Note that what happens here is that a table row set is created for each match from the DB.

[benson]

At now i have some code but it ios not working preciely how i want it. At first the code should determine if there shuold be two besides eachother(Like this [] Frans [] Duits)
Then it should determine how many there shoulde be one the left side and how many there should be on the right side .
How can this be done ?

<?php
session_start();
// start de sessie
$_SESSION['taal'] == $_POST['taal'];

// Maken van vrije keuze arrays
$vwoarray = array("Grieks","Latijn","Duits 2","Frans 2","Economie","Aardrijkskunde","Scheikunde 1","Natuurkunde 1");
$havoarray= array("Duits 1","Duits 2","Frans 1","Frans 2","Handvaardigheid","Tekenen","Muziek","Economie 1","Economie 2","Biologie","Scheikunde 1","Natuurkunde 1","Informatica","Maatschappijleer","Manegement & Organisatie","Lo 2");

//vaststellen welke array gebruikt moet worden
if($_SESSION['niveau'] == "havo")
{
$usedarray = $havoarray;
}
else
{
$usedarray = $vwoarray;
}
$numvakken = count($usedarray);
$numcolumn = ceil($numvakken / 8 * 2);
?>

      <table cellspacing="10" cellpadding="0" border="0" width="300">
  <tbody>
<tr>
<?php
$i = 0;
while ($i <= $numvakken)
{
?>
<td width="10" valign="top"><input type="checkbox" name="vrkeuze" value="<?php echo $usedarray[$i]; ?>"></td>
<td width="140" valign="top"><?php echo $usedarray[$i]; ?></td>
<?php
if($i/$numcolumn != 0)
	{
	echo "</tr><tr>";
	}
$i++;
}
?>
    </tr>
  </tbody>
</table>