my $INFO = $DBH->prepare("SELECT SND.ACC, M.ID, M.FULLNAME FROM U_REC as M JOIN U_USERS as SND ON SND.ACC = M.ID WHERE CASE WHEN (SELECT SUM(status = ?) FROM U_REC) > 0 THEN M.status = ? ELSE M.status = ? OR M.status = ? OR M.status = ? END ORDER BY created ASC"); $INFO->execute('new', 'ne1', 'ne2', 'ne3', 'ne4'); my (@data,$ACC,$ID,$FULLNAME); foreach (@data = $INFO->fetchall_arrayref()) { $ACC = $data[0]; $ID = $data[1]; $FULLNAME = $data[2]; } ##

##














	sample dataTable
	
    
        
            
            
        
    
    
        
            Ex: (10123) #ID goes here
            Ex: (Jane Deo)  #Fullname goes here
        
        
            Ex: (20911) #ID goes here
            Ex: (John Deo) #Fullname goes here


Ex: (10123) #ID goes here	Ex: (Jane Deo) #Fullname goes here
Ex: (20911) #ID goes here	Ex: (John Deo) #Fullname goes here