Hi Mark,
> This may be a very simple problem but I just can't see the
> solution.
> # prepare and execute query
> my $sth = $dbh->prepare("SELECT Time,Person
> FROM bookingform
> WHERE Date = '$totalYear'");
> $sth->execute();
>
> while(my $Pers
In your retrieval of the values, i believe you would need to store the
results in an array, since you are returning more than one value. So in
your example.$row[1] would be your person value.it should look like...
while(my @row = $sth->fetchrow_array)
{
print "$row[1]";
}
As for the sele