".$SQL; $rs=mssql_query($SQL, $dbcon); if (mssql_num_rows($rs)>0) { $SelectableColExist=true; } else { $SelectableColExist=false; } //I create a different SQL depending if the Visible column exist or not in the database if ($SelectableColExist==true){ $SQL="SELECT RefCache, RefId FROM dbo.Reference WHERE (Selectable = 1)"; } else { $SQL="SELECT DISTINCT RefCache, RefId FROM dbo.Reference INNER JOIN dbo.PTaxon ON Reference.RefId = PTaxon.PTRefFk"; } //-------------------------------------------------------------------------------------------------------------------------- //Select all the available sources to present into the Reference box echo "
".$SQL; $rs=mssql_query($SQL, $dbcon); ?>

Search!

Fill in the empty field in order to query the database for a specific name. Use the asterisk (*) as a wild card (e.g. Abi* will find all names starting with Abi, Abies alba * will find the names of subspecies etc. of Abies alba, *aaa* will find all names containing triple a, and Ab*ba will find Abies alba etc.). The input must contain at least three letters. The search is only on the name itself, so please do not include authorship or year of publication.

Search for a botanical name like "Luzula*":

Name:
Select Source:

N.B.: Do not include taxonomic authors.