in reply to selecting from a mysqldatabase

I highly suspect that the error is with your foreach $elem(@compile) line. Stick use Data::Dumper to your code, and check the values of your @compile.

use Data::Dumper; my @compile ... print "<pre>\n", Dumper(\@compile), "\n</pre>\n";
Another possibility is that your table has duplicate data. To check for this, simply insert a print after the while loop -

while (my($identifier)=...) { print "<tr><td><font color=#FF0000>", # <- insert print "$identifier</font></td></tr>\n"; foreach ... }

Replies are listed 'Best First'.
Re: Re: selecting from a mysqldatabase
by bory (Beadle) on Nov 24, 2003 at 11:10 UTC
    I found the problem: i had had duplicate values in @compilea from my mistake.Now it's printing ok. Thank you very much for your help.