Hi,
This may be a very simple problem but I just can't see the solution. I'm
trying to select a person's name from a database table but it quits once it
reachs an entry where no person's name exists. Without pre-populating the
table is there a way around this; just selects all a columns details
whether empty or not?

code:

# prepare and execute query
my $sth = $dbh->prepare("SELECT Time,Person
                         FROM bookingform
                         WHERE Date = '$totalYear'");
$sth->execute();

while(my $Person = $sth->fetchrow_array)
{
   print "<td class=\"cellDetail\" valign=\"top\" >$Person</td>";
}

$totalYear is a certain value.
$Person is sometimes empty though. 
Thanks in advance,
Mark.


**********************************************************************
This document is strictly confidential and is intended for use by
 the addressee unless otherwise indicated.
Allied Irish Banks
**********************************************************************


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to