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]