I am trying to write a simple program like the one below that lets users at a console select an active employee. However, because they are not supposed to see the employee's employee number I can't figure out a way to let them make the selection. I thought I could do it with a counter ($i) but don't know of a way to associate the date with the count. Any ideas would be greatfully appreciated.<br><br>Thanks,<br><br>Richard<br><br>#!/usr/bin/perl -w<br><br>my $q = "SELECT emp_no, first_name, last_name, mobile_ph<br> FROM employee<br> WHERE end_date IS NULL"<br>my $sth->prepare($q);<br><br>my ($emp_no, $f_name, $l_name, $ph);<br>$sth->execute();<br>$sth->bind_columns(\($emp_no, $f_name, $l_name, $ph);<br><br>my $i;<br>while($sth->fetch) {<br> $i++;<br> print $i . " " . $name . " " $f_name . " " . $l_name . " " . $ph ."\n";<br>}<br><br>print "Somehow make a selection based on what you're allowed
to view\n";<br>my ($sel = <STDIN>);<br><br><BR><BR>Your beliefs become your thoughts. Your thoughts become your words. Your words become your actions. Your actions become your habits. Your habits become your values. Your values become your destiny. -- Mahatma Gandhi