DNA Bank Network - Data Cleaning
Logout
.
DNA Extraction Number: *
doppelte Einträge:
No entries found empty."; } else { $count = mysql_num_rows($sql1); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } $sql2 = mysql_query("SELECT DISTINCT tablednabanknumbers.ID_DNA, tablednabanknumbers.Dna_Bank_Number " . ", COUNT(*) AS anzahl FROM tablednabanknumbers " . "GROUP BY tablednabanknumbers.Dna_Bank_Number HAVING anzahl > 1"); if(!mysql_affected_rows()) { echo "
No double entries found.
"; } else { echo "
Folgende DNA Nr. sind doppelt erfasst worden:
"; while($roww = mysql_fetch_object($sql2)) { $formDna = $roww->Dna_Bank_Number."; "; echo $formDna; } } ?>
"; } ?>
Relation to Voucher: *
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA samples without link to voucher: *
No entries found."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found without link to voucher.
"; } else { echo "
".$count. " entries found without link to voucher.
"; } } ?>
Tissue:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
Preservation:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Type:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Extraction Method: *
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Extraction Date: *
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Extraction Staff: *
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Purification Method:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
Ratio of absorbence
OD
260nm
/OD
280nm
:
OD
260nm
/OD
230nm
:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } echo "
"; $sql = mysql_query('SELECT ID_DNA FROM tablednabanknumbers WHERE Absorbance280 = ""'); if(!mysql_affected_rows()) { echo "
No entries found empty.
"; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Concentration:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Quality:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
DNA Quality Check Date:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
Location Stock Solution:
No entries found empty."; } else { $count = mysql_num_rows($sql); if($count == 1) { echo "
".$count." entry found empty.
"; } else { echo "
".$count. " entries found empty.
"; } } ?>
* Required field