Recently I was asked to implement search in long dropdowns. Our customer got stressed each time when he had had to find a product in the loooong list.
I tried to search for a solution in the Internet and there are at least two fancy ones. But one of them is very slow for long lists (well, we do need to search in long lists first of all) and the other one is simple but doesn't allow to select items manually.
So I ended up with very easy solution

http://newgradlife.blogspot.com/2010/03/resume-samples-resume-writing-resume.html

International English Language Testing System (IELTS)

Use the following table to determine how many points you will be awarded
for your test scores with the International English Language Testing
System (IELTS):

http://dean.edwards.name/packer/

.

http://honda.autoportal.ua/newcars/honda-accord-2008/foto-73138.html#scroll

Here's the problem:
You got SSL certificate from any issuer, you are happy that you can now use https!
You've installed your site, tuned your apache server to listen 443 port and include the certificate for your virtual host.... and you stuck with entering pass phrase each time when you restart apache! Even worse, you have not too much visitors on your site and your apache server shuts down to free resources. And it just can't start without entering that damn pass phrase!

Assume that you have incoming parameter "ModerationStatus" that is responsible for filtering results.
Depending on this parameter you need to show either all rows or limited number of rows. Here's the example of the routine how this can be made with the least effort:

CREATE PROCEDURE `Photo_Get_List`(ModerationStatus tinyint(1))
BEGIN
SET @query = 'SELECT * FROM Photos';
IF ModerationStatus IS NOT NULL THEN
SET @query = CONCAT(@query, ' WHERE ModerationStatus = ', ModerationStatus);
END IF;
PREPARE statement FROM @query;
EXECUTE statement;
DEALLOCATE PREPARE statement;

It's strange... but when I searched for the js snippet for this functionality I either got out-of-date javascript snippets that don't work anywhere else except IE 5 (I guess) or strange monsters that allow to save current page anywhere except browser itself!