in reply to Perl Mysql Null Recordset

The execute statement returns 0E0 if no records were affected/returned. Instead of :
if($rs1 != 'NULL')
Try:
if($rs1 ne "0E0")
Also, I'm pretty sure the != test is for numeric values only.

From the MySQL Reference Manual:
If no rows are affected, execute returns "0E0" , which Perl treats as zero but regards as true. If an error occurs, execute returns undef.