"); } else { if($message==1) { echo "Full Tools List

"; } elseif ($message==2) {echo "New Tools as of September 2005

"; } elseif ($message==3) { echo "Search Results

"; } elseif ($message==4) { echo "Search Results by Focus Area

"; } elseif ($message==5) { echo "Search Results by Stakeholder Type

"; } else { echo ""; } print("Displaying ".$numrows." Tools

"); } while($array = mysql_fetch_array($result)) { echo "

Tools

< Tools menu


$tooltitle
$description
$focusid
$supportid"; } elseif($key=="fid") { $allsearch = ""; $sql= "SELECT * FROM tools WHERE focusid=$val "; //$search=$allsearch; $message=4; } elseif($key=="supid") { $allsearch = ""; $sql= "SELECT * FROM tools WHERE supid=$val "; //$search=$allsearch; $message=5; } else { echo "Please use the links to access any of the tools"; } if(!empty($organization)) { $orgsearch= "MATCH (organization) AGAINST ('$organization')"; } if(!empty($tooltitle)) { $ttsearch= "MATCH (tooltitle) AGAINST ('$tooltitle')"; } if(!empty($description)) { $descsearch= "MATCH (description) AGAINST ('$description')"; } if(!empty($focusid)) { $focussearch= "focusid=$focusid"; } if(!empty($supportid)) { $suppsearch= "supid=$supportid"; } // testing array version $searcharray=array(); $searcharray[]=$orgsearch; $searcharray[]=$ttsearch; $searcharray[]=$descsearch; $searcharray[]=$suppsearch; $searcharray[]=$focussearch; for($x=0;$x
"); print("Your search returned no results, please try again"); print("
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; } mysql_close($connection); ?>
".wordwrap($array[tooltitle], 20)."
Organization: ".$array[organization]."
About this tool: ".ShortenText($array[description])."

Click here for full description and tool.