* element formInstitutionCode
* @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 ReferenceText FROM reference WHERE ReferenceText LIKE "%'.$searchq.'%" GROUP BY ReferenceText LIMIT 50)
UNION
(SELECT ReferenceShort FROM reference WHERE ReferenceShort LIKE "%'.$searchq.'%" GROUP BY ReferenceShort LIMIT 50)';
$getRecord = mysqli_query($GLOBALS["___mysqli_ston"], $getRecord_sql);
if(strlen($searchq)>0){
if(mysqli_num_rows($getRecord)) {
echo '';
$max = mysqli_num_rows($getRecord);
for ($i=0; $i<=$max-1; $i++) {
$row=mysqli_fetch_array($getRecord);
{
$s = "- " . $row['ReferenceText'] . "
";
echo $s;
}}
if ($max == '50')
echo "- ...
";
echo '
';
}
} ?>