<?php 
/**
* Suggestion List for sptool/inputspecimen, sptool/inputmixedspecimen
* <br/><br/>
* element formGenus1
* @author Gabriele Droege, DNA Bank Network <contact@dnabank-network.org>
* @version 2.0
* @package Ajax
* @copyright Copyright © 2011 DNA Bank Network http://www.dnabank-network.org<br>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.Author as Author FROM 
						(SELECT ID_Taxonidentified,Author AS Author FROM sptooltaxa WHERE Author LIKE '".$searchq."%'
						UNION 
						SELECT ID_Taxonidentified,AuthorParenth AS Author FROM sptooltaxa WHERE Author LIKE '".$searchq."%'
						) as taxa
						GROUP BY taxa.Author LIMIT 50";
		$getRecord		=	mysqli_query($GLOBALS["___mysqli_ston"], $getRecord_sql);

	if(strlen($searchq)>0){
  if(mysqli_num_rows($getRecord)) {

	echo '<ul>';
  $max = mysqli_num_rows($getRecord);
  for ($i=0; $i<=$max-1; $i++) {
      $row=mysqli_fetch_array($getRecord);
      {
      $s = "<li id=A".$i." onclick='javascript:SelectAuthorParenth4(this.innerHTML);'><a>" . $row['Author'] . " <strong>(" . $row['number'] . ")</strong></a></li>";
      echo $s;

  }}
  if ($max == '50')
  echo "<li id=".$max."><span>...</span></li>";
	echo '</ul>';
}

} ?>