Location: PHPKode > projects > Open Chamber of Commerce > ococ/content/directory_out_txt.php
<?php 
/*
    Consolidated Member Directory:
    Outputs the member roster
    in comma-delimited text format.
*/

include '../inc/db.inc';
include '../inc/error.inc';
include '../inc/site_globals.inc';
include '../inc/html_entity_decode.php';

header('Content-Type: text/text');

// log in to the database
if (!($db = @ mysql_connect($hostName, $userName, $passWord)))
   showError();

if (!( @ mysql_select_db($databaseName,$db)))
   showError();

$sql = "SELECT * FROM $members ORDER BY Biz ASC";
if(!$result = mysql_query($sql, $db))
  showError();

while($myrow = mysql_fetch_array($result, MYSQL_ASSOC))
{
  foreach($myrow as $tag => $data)
  {
    print htmlspecialchars(html_entity_decode($data));
    if($tag != "CEmail")
      print ",";
  }
  print "\n";
}

?>
Return current item: Open Chamber of Commerce