function buffer_films($qi) { $ad = " WHERE filmi_nimi LIKE '".$qi."%'"; $addon = $qi == "ALL" ? "" : $ad; if($addon == "" AND $qi == "0") $addon = " REGEXP '^[0-9].*$'"; $q = @mysql_query("SELECT filmi_nimi FROM filmid".$addon); $output = "
"; while($i = mysql_fetch_assoc($q)) { $output .= "
".$i["filmi_nimi"]."
"; } return (!empty($output) ? $output : "
filmid databaasis puuduvad!
"); }