3 <TITLE>Customer Search</TITLE>
5 <BODY BGCOLOR="#e8e8e8">
10 <FORM ACTION="cust_main.cgi" METHOD="post">
11 Search for <B>Order taker</B>:
12 <INPUT TYPE="hidden" NAME="otaker_on" VALUE="TRUE">
14 my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_main")
15 or eidiot $dbh->errstr;
16 $sth->execute() or eidiot $sth->errstr;
17 # my @otakers = map { $_->[0] } @{$sth->selectall_arrayref};
19 <SELECT NAME="otaker">
20 <% my $otaker; while ( $otaker = $sth->fetchrow_arrayref ) { %>
21 <OPTION><%= $otaker->[0] %></OTAKER>
24 <P><INPUT TYPE="submit" VALUE="Search">