My Sightings

$result = db_query('SELECT DISTINCT field_organism FROM {organism}');
$num_results = $result->num_rows;
for ($i=0; $i<$num_results; $i++) {
$row = $result->fetch_assoc();
$org = $row['field_organism'];
$name = strtolower($org);
$name = str_replace(" ","_",$name);
$value = $name;
$id = $name.'_id';
echo "

'."\n";
}
?>

\n";
echo '
'."\n";
echo $org."\n";
echo '