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]
