$min_len) { $new_str[$i] = $string; $i++; } } $t_name = implode(" ", $new_str); unset($new_str); $t_name = preg_replace($pattern, $replace, $t_name); $t_nameL = strtolower($t_name); return $t_nameL; } // PCL Output function pcl_output($id) { if ($id == 0) return false; $query1 = tep_db_query("select c.parent_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = $id and cd.categories_id = $id"); $pcla = array(); while ($pc_values = tep_db_fetch_array($query1)) { $pc_header = $pc_values[categories_name]; $parent_id = $pc_values[parent_id]; $type = "c"; $query2 = tep_db_query("select c.categories_id, c.parent_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = $id and c.categories_id = cd.categories_id"); while ($q2v = tep_db_fetch_array($query2)) { $q2_id = $q2v[categories_id]; $q2_head = $q2v[categories_name]; array_push($pcla, "$q2_id$q2_head"); } } $i = 0; $cPath = tep_get_path($id); echo ""; foreach ($pcla as $key => $data) { $split = explode("", $data); $p_id = $split[0]; $p_head = $split[1]; $cPath = tep_get_path($p_id); if ($i == 2) { echo ""; $i = 0; } echo ""; $i++; } echo "
Shop our Online Catalog: ". $pc_header . "

"; } // Sub Topic Sister Linking function sub_topic_links($starting_topic_id) { echo ""; //echo ""; $parent_query = "SELECT parent_id FROM topics WHERE topics_id='". $starting_topic_id ."'"; $parent_results = tep_db_query($parent_query); $parent_id = tep_db_fetch_array($parent_results); $parent_id = $parent_id['parent_id']; if ($parent_id == 0) { $parent_id = $starting_topic_id; } /* $parent_name_query = "SELECT topics_name FROM topics_description WHERE topics_id='". $parent_id ."'"; $parent_name_results = tep_db_query($parent_name_query); $parent_name = tep_db_fetch_array($parent_name_results); $parent_name = $parent_name['topics_name']; $parent_name = preg_replace('/ /', '', $parent_name); */ $i = 0; $topics_query = "SELECT t.topics_id, td.topics_name, t.parent_id FROM topics t, topics_description td WHERE (t.parent_id='". $parent_id ."' OR t.parent_id='". $starting_topic_id ."') AND t.topics_id = td.topics_id ORDER BY td.topics_name"; $topics_results = tep_db_query($topics_query); while ($subs = tep_db_fetch_array($topics_results)) { $topic_id = $subs['topics_id']; $topic_name = $subs['topics_name']; if ($subs['parent_id'] == 0) { $tPath = "tPath=". $subs['topics_id']; } else { $tPath = "tPath=". $subs['parent_id'] ."_". $subs['topics_id']; } if ($i == 0) { echo ""; } if ($topic_id != $starting_topic_id) { echo ""; $i++; } if ($i == 3) { echo ""; $i = 0; } } echo "
Related Topics:
  • ". $topic_name ."
  • "; } // Sister Artile Linking function sister_article_linking($current_id) { $fetch_cat = tep_db_query("SELECT at.topics_id, t.parent_id, td.topics_name FROM articles_to_topics at, topics t, topics_description td WHERE at.articles_id = $current_id AND at.topics_id = t.topics_id AND td.topics_id = t.topics_id"); while ($result = tep_db_fetch_array($fetch_cat)) { $tID = $result['topics_id']; $pID = $result['parent_id']; $tName = $result['topics_name']; } if ($pID == 0) { $tPath = "tPath=". $tID; } else { $tPath = "tPath=". $pID ."_". $tID; } echo ""; echo "

    "; sub_topic_links($tID); echo "

    "; echo "Back to main topic: $tName
    "; $link_builder_query = tep_db_query("SELECT ad.articles_id, ad.articles_name, at.topics_id, at.articles_id FROM articles_description ad, articles_to_topics at WHERE at.topics_id='$tID' AND at.articles_id = ad.articles_id ORDER BY ad.articles_name"); while ($link_builder = tep_db_fetch_array($link_builder_query)) { $a_id = $link_builder['articles_id']; $a_name = $link_builder['articles_name']; $aPath = "articles_id=". $a_id; if ($current_id == $a_id) { } else { echo "$a_name
    "; } } print ("
    "); } ?> Al Nash

    Nash, Al


    Al Nash graduated from the University of Houston with a Bachelor of Fine Arts degree in 1969. At that time the U. S. Army and the Vietnam War intervened and, over the years, circumstances took Al elsewhere. He remained with the Army and retired in 1995 as a lieutenant colonel. He retired from subsequent civilian employment with the Army in 2006 and then returned to his first love ... art.