* element formGenus1
* @author Gabriele Droege, DNA Bank Network
* @version 2.0
* @package Ajax
* @copyright Copyright © 2011 DNA Bank Network http://www.dnabank-network.org
The contents of this file are subject to the Mozilla Public License Version 1.1
* @filesource
* @license http://www.mozilla.org/MPL/ MPL
*/
/**
* calling connection to database
*/
include('../config/head.php');
$searchq = strip_tags($_GET['q']);
$getRecord_sql = "SELECT count(taxa.ID_Taxonidentified) as number , taxa.Epithet as Epithet FROM
(SELECT ID_Taxonidentified,SpecificEpithet AS Epithet FROM sptooltaxa WHERE SpecificEpithet LIKE '".$searchq."%'
UNION
SELECT ID_Taxonidentified,InfraspecificEpithet AS Epithet FROM sptooltaxa WHERE InfraspecificEpithet LIKE '".$searchq."%'
) as taxa
GROUP BY taxa.Epithet LIMIT 50";
$getRecord = mysqli_query($GLOBALS["___mysqli_ston"], $getRecord_sql);
if(strlen($searchq)>0){
if(mysqli_num_rows($getRecord)) {
echo '';
}
} ?>