my oops - here's the "search_item" code... 
sub search_item($$$$) {
  #*
  # to search for a list of user IDs which match one criteria (ie: eye
+_clr=1)
  # searches can only happen with the logged in user
  # we must not include the logged in user in the search results!
  # nor should we include those that are banned or security level 888 
+or higher
  #*
  my ($db, $usersRef, $name, $value) = @_; # a DBH && a reference to a
+ list of users to search && the name of the item to search for && the
+ value the named item must be
  my @searched; # a list of UIDs which match the given name=value pair
+s

  my $query = "select ID from users where $name='$value';";
  my $resultsRef = sql_execute($db, $query);
  if ($resultsRef) {
    if (ref $resultsRef eq "ARRAY") {
      # we have multiple hits!
      my @array = @$resultsRef;
      foreach my $hit (@array) {
        # $hit is a hash reference.
        my %hash = %$hit;
        push @searched, $hash{ID};
      }
    } else {
      # we only have one hit!
      my %hash = %$resultsRef;
      push @searched, $hash{ID};
    }
  }

  # it is very possible to have an empty "searched" array.
  # this is totally ok.

  return @searched; # an array of uid's which matched the specified cr
+iteria, minus the logged in user's uid
  #usage: my @results = search_item($db, \@uList, "eyes", "1");
}

[download]

In reply to Re^2: DB search results using DBI...execute by jamroll
in thread DB search results using DBI...execute by jamroll

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.