2) { $db=mysql_connect($dbhost, $dbuname, $dbpass) or die ("MySQL verbinding mislukt"); $dbid = "deb3977n3_foodstuff"; mysql_select_db($dbid, $db) or die ("Database verbinding mislukt"); $query="SELECT * FROM additives where $my_lang ORDER BY sortindex"; $additives_data = mysql_query($query); $no_records=mysql_num_rows($additives_data); if ($no_records==0) { $advice="No results for '${searchstr}' were found."; } if ($no_records==1) { $advice="Search string '${searchstr}' was found in 1 additives."; } if ($no_records>1) { $advice="Search string '${searchstr}' was found in ${no_records} different additives."; } $title_plus=", search results for ${searchstr}"; } else { if (strlen($searchstr)>0) { $advice="Search string '${searchstr}' is too short."; } } // begin of story $story=$menu; $story.=<<

E-numbers search page${title_plus}

#GOOGLEFORFOOD#
Use this search page if you want to find food additives by part (at least 3 characters) of their names.

If the number of results is too high either search for additive names in a single language (currently English and Dutch) or enter a larger part of the name.

The list of results is divided per functional group.

$advice

Part of the name:
Language:
ADDITIVE_INTRO; // additiional option must wait // //