<?php
include 'config2.php';
include 'opendb.php';

// here's a quickie function to print the address from
// an associative array. We'll use it in a moment
function printaddr($addr){
   echo "<b>{$addr['NameF']} {$addr['NameL']}</b><br />\n";
   echo "<b>" . nl2br($addr['Address']) . "</b><br />\n";
   echo "Home: {$addr['Home']}<br />\n";
   echo "Work: {$addr['Work']}<br />\n";
   echo "Cell: {$addr['Cell']}<br />\n<br />\n";
}

// get the data from DB
$query  = "SELECT NameF, NameL, Address, Home, Work, Cell FROM Contacts WHERE  Affiliation = 'family' ORDER BY NameL";
$result = mysql_query($query);

// now put everything in one big array
$BigAddressArray = array();
while($row = mysql_fetch_array($result)){
   $BigAddressArray[] = $row;
}

// chunk the array for three column output
// note that if you wanted 2 or 4 or 12 column
// output you only need to change the last
// argument in array_chunk(). Everything else
// stays the same.
$AddressTable = array_chunk($BigAddressArray, 3);

echo "<table>\n";
foreach($AddressTable as $TableRow){
   echo "<tr>";
   foreach($TableRow as $TableCell){
      echo '<td valign="top" width="250px">';
      printaddr($TableCell);
      echo '</td>';
   }
   echo "</tr>\n";
}
echo "</table>\n"; 

include 'closedb.php';
?>
<form><center>
<input type="button" value="Print This Page" onClick="window.print()" /></center>
</form>

echo "Home: {$addr['Home']}<br />\n"; 

if (!empty({$addr['Home']})) echo "Home: {$addr['Home']}<br />\n"; 

<



function printaddr($addr){

   echo "<b>{$addr['NameF']} {$addr['NameL']}</b><br />\n";

   if (!empty({$addr['Address']})) echo "Address: {$addr['Address']}<br />\n"; 

   if (!empty({$addr['Home']})) echo "Home: {$addr['Home']}<br />\n"; 

   if (!empty({$addr['Work']})) echo "Work: {$addr['Work']}<br />\n"; 

   if (!empty({$addr['Cell']})) echo "Cell: {$addr['Cell']}<br />\n"; 

} 

function printaddr($addr){
   echo "<b>{$addr['NameF']} {$addr['NameL']}</b><br />\n";
   if (!empty($addr['Address'])) echo "Address: {$addr['Address']}<br />\n";
   if (!empty($addr['Home'])) echo "Home: {$addr['Home']}<br />\n";
   if (!empty($addr['Work'])) echo "Work: {$addr['Work']}<br />\n";
   if (!empty($addr['Cell'])) echo "Cell: {$addr['Cell']}<br />\n";
}