0) // { $getRecord_sql .= 'AND tablecachehighertaxa.Family = "'.$searchr.'" '; // } $getRecord_sql .= 'GROUP BY tablecachetaxonidentified.NameAuthorYear ORDER BY tablecachetaxonidentified.NameAuthorYear LIMIT 50'; $getRecord = mysql_query($getRecord_sql); if(strlen($searchq)>0){ if(mysql_num_rows($getRecord)) { // ---------------------------------------------------------------- // // AJAX Response // // ---------------------------------------------------------------- // // Change php echo $row['name']; and $row['department']; with the // // name of table attributes you want to return. For Example, if you // // want to return only the name, delete the following code // // "
"// // You can modify the content of ID element how you prefer // echo ''; } } ?>