RE: Empty values

2003-12-01 Thread Thomas Bätzler
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

Re: Empty values

2003-12-01 Thread Christopher G Tantalo
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