Thanks for the hit. I enabled the warning program and found out that Perl thought the SQL variables where Perl variables and I placed the \ character before all of the @s.

Now, another question, how do I disable the warning program in one specific section of code, because I get the following warning when I am aware I'm going to have a error. (I'm talking about the code most recently posted)

Code

Content-type: text/html

[Thu Feb 28 22:21:11 2013] 111.pl: Use of uninitialized value $rows[1] in join or string at 111.pl line 27. <html><head><title>TST</title></head><body>1

I was going to recommend assigning '' an empty string to all undef fields, which is only 1 line of code, but it's just as easy to disable the uninitialized warning. However, you SHOULD NOT get into the habit of circumventing warnings just because you don't want to deal with it in a more appropriate manner.

Take note that I broke up the statements in the while loop as well as the sql statement. The sql could be broken out a little more. Putting multiple statements on a single line is bad style and should be avoided.