comment on

I'm not sure exactly what you're asking, but if it the problem is that you can't remember, it seems that a brief look through perldoc would've refreshed your memory.

If I understand what you're wanting, this should get you going:

$sth = $dbh->prepare($sql);
$sth->execute() || die $sth->errstr;

my @line;
while ($pointer = $sth->fetchrow_hashref)
{
   push @line, $pointer->{'LINE'};
   $ins =$pointer->{'INS#'};
   $number =$pointer->{'NUMBER#'};

   if($line_type)
   {        
      $result = "<td><a href=found.html?line=$line>Found $line</td><br
+>";
      exit;
   }
   else
   {
      print "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=notfound.ht
+ml\"> \n";
      exit;
   }
}
      
print @line;
#
# or 
# foreach my $line (@line)
# {
#    print "$line\n";
# }
[download]

Update: CombatSquirrel beat me to the punch. I hate telephones.

If things get any worse, I'll have to ask you to stop helping me.

In reply to Re: While Loop Problem! by shockme
in thread While Loop Problem! by Anonymous Monk

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Perl: the Markov chain saw
	PerlMonks