Links to outrigger paddling related websites

<?php

//tell how to post them
if (user_access('create Link content')) {
$add_l = l(t('Add a link'), 'node/add/link', array('title' => t('Add a link to the directory.')));
}
else {
$add_l = t('login or register to add a link', array('%login' => url('user/login'), '%register' => url('user/register')));
}
print '

' . $add_l . '

';

$node_type = "flexinode-5";

$sql = "SELECT n.title, n.nid, d.name, IFNULL(a.name,d.name) parent FROM {node} n LEFT JOIN {term_node} t ON n.nid = t.nid LEFT JOIN {term_data} d ON t.tid = d.tid LEFT JOIN {term_hierarchy} h ON d.tid = h.tid LEFT JOIN {term_data} a ON a.tid = h.parent WHERE n.type = '$node_type' ORDER BY parent, d.name, n.title" ;
$result = db_query($sql);

while ($node = db_fetch_object($result)) {

if ($node->name != $prev_node_name) {


  if ($node->parent != $prev_parent_name) {

$content .= '

' . $node->parent . '

';

  }
 if ($node->parent != $node->name) {

$content .= '

' . $node->name . '

';

	}

} 

$content .= '

';
$prev_parent_name = $node->parent;
$prev_node_name = $node->name;

}
//$content = theme('node_list', $items, $title);
$content = '

' . $content . '

';
print $content;

print '' . $add_l . '
';
?>