Do you know the name of the Organisation? All $sql = "Select Distinct Name, OrganisationID FROM Organisations Where Name <> '' order by Name;"; // and Search = true //set rs = Server.CreateObject("ADODB.Recordset") //rs.open sql, "DSN=euro" //do while not rs.eof $result = mysql_query($sql); $nbRows = mysql_num_rows($result); for($i=0;$i<$nbRows;$i++) { ?> echo mysql_result($result,$i,"Name")?> } ?>
Coverage of Organisation
All $sql = "SELECT Distinct Coverage FROM Organisations Where Coverage <> '';"; //set rs = Server.CreateObject("ADODB.Recordset") //rs.open sql, "DSN=euro" // do while not rs.eof $result = mysql_query($sql); $nbRows = mysql_num_rows($result); for($i=0;$i<$nbRows;$i++) { ?> echo mysql_result($result,$i,"Coverage") ?> }?>
What area of science/activity are you interested in?
All $sql = "SELECT Distinct AreaScienceID, AreaScience FROM AreaScience;"; $result = mysql_query($sql); $nbRows = mysql_num_rows($result); for($i=0;$i<$nbRows;$i++) { ?> echo mysql_result($result,$i,"AreaScience")?> }?>
What type of Organisation are you looking for?
All $sql = "SELECT Type, TypeID FROM Types Where Type <> '';"; $result = mysql_query($sql); $nbRows = mysql_num_rows($result); for($i=0;$i<$nbRows;$i++) { ?> echo mysql_result($result,$i,"Type")?> }?>
Do you want to specify a particular county?
All $sql = "SELECT Distinct Country FROM Organisations Where Country <> '';"; $result = mysql_query($sql); $nbRows = mysql_num_rows($result); for($i=0;$i<$nbRows;$i++) { ?> echo mysql_result($result,$i,"Country")?> }?>