## connect to DB ## Run my SQL statements while (@row = $sth->fetchrow_array) { $employee_id = $row[0]; $last_name = $row[1]; $first_name = $row[2]; $cell_phone_number = $row[3]; $email = $row[15]; $information_date = $row[17]; ### clean up for web## eq ""); $last_name = " " if ($last_name eq ""); $first_name = " " if ($first_name eq ""); $cell_phone_number = " " if ($cell_phone_number eq ""); $email = " " if ($email eq ""); $information_date = " " if ($information_date eq ""); ## then print "$PRINT the "STUFF" retrieved"; ## disconnect #### check if record exists { if not present{ &add_new; } else { print " RECORD EXISTS"; } }