Google is dealing with Accidental Clicks

Google is moving to reduce accidental clicks.

This post post explains it well http://blogoscoped.com/archive/2007-11-13-n42.html but you can read it at Google Adsense Blog. This could mean decrease in revenue for some. Despite that I think it is a fair change as it gives the advertisers better value for their money. I am not sure why it was not like this from before.

Happy advertisers are likely to keep on advertising. This quote from the the article sums it up. It says, "By reducing accidental clicks, we hope to increase advertiser campaign value and satisfaction, encouraging additional spend and facilitating higher monetization for all publishers."

I insert data in to multiple tables in MySql

I saw this question on Techjamaica forum and noted it. Interesting question and interesting answer.

Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?

Seems like the answer is no

Can I you insert data multiple times into the same table with one statement too.

INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');

Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html

color schemes

Color
------------
http://www.colorsontheweb.com/colorschemes.asp?search=&category=Corporate
http://www.colorschemer.com/
http://www.articleinsider.com/article/229290
http://www.colorschemer.com/galleria_info.php
http://colorschemer.com/schemes/?start=331
http://www.webwhirlers.com/colors/colorschemes.asp
http://dianev.com/web-design-help/web_design_basics/color.html
http://dianev.com/web-design-help/web_design_basics/website_color_schemes.html
http://www.smashingmagazine.com/category/color/

examples
----------------
http://www.aviva.com/
http://www.norwichunion.com/

http://mobile.ups.com
pda.sky.com
bbc.co.uk/mobile
mobile.wunderground.com
pdaportal.com
pdahomepage.com
http://www.purelymobile.co.uk/

• Google (http://www.google.com/m/products)
• Yahoo Messenger (http://mm.yahoo.com)
• News.com (http://m.news.com)
• CNET Mobile (http://m.cnet.com)
• Weather.com (http://palm.xhtml.weather.com/xhtml/)
• Digg (http://mobits.com/digg/)
• Reuters (http://mobile.reuters.com/)
• New York Times (http://mobile.nytimes.com/)
• Business Week (http://pda.businessweek.com/index.html)
• Dictionary.com (http://dictionary.com/wml/)
• StreetIQ podcasts (http://m.streetiq.com/)
• Amazon.com (http://www.amazon.com/gp/aw/h.html)
• Flickr (http://m.flickr.com/)
• GameGeeks (http://www.geek.com/gaming/portable/)

http://blogs.techrepublic.com.com/hiner/?p=487?tag=1-1-11-0-0

http://www.mobidish.com/
Adshandy.com
http://www.enpocket.com/


http://realplayer.com/blog/?pageid=broadBandHomePage&pageregion=footer&src=realhome_bb_0_3_1_0_0_1_0&pcode=rn&opage=realhome_bb
http://archives.neohapsis.com/archives/fulldisclosure/2008-03/0157.html
http://www.download.com/8301-2007_4-9890945-12.html

Mysql Group By

More on Group By, Having, in your SELECT queries
http://www.databasejournal.com/features/mysql/article.php/3469351
http://rpbouman.blogspot.com/2007/05/debunking-group-by-myths.html

http://www.mysql.com/news-and-events/newsletter/2003-06/a0000000190.html

MYSQL Documentation
http://dev.mysql.com/doc/refman/4.1/en/select.html
last comment very useful
http://dev.mysql.com/doc/refman/4.1/en/group-by-modifiers.html
OPtimisations
http://dev.mysql.com/doc/refman/4.1/en/select-speed.html
http://dev.mysql.com/doc/refman/4.1/en/where-optimizations.html
http://dev.mysql.com/doc/refman/4.1/en/query-cache-in-select.html

String manipulation

proper case strings
http://www.php.net/manual/en/function.strtoupper.php#68340
http://www.sitepoint.com/blogs/2005/03/15/title-case-in-php/

Google Gadgets

http://www.google.com/apis/gadgets/basic.html
http://www.google.com/apis/gadgets/remote-content.html#Fetch_JSON
http://www.google.com/apis/gadgets/reference.html#Userprefs_Ref

More Character Issues

Mysql

Mysql dump and character issues

PHP

http://www.php.net/htmlspecialchars
http://www.php.net/manual/en/function.htmlentities.php
http://www.php.net/manual/en/function.html-entity-decode.php

http://www.dragonwinds.com/resources/html-codes.shtml
http://www.htmlhelp.com/reference/html40/entities/latin1.html
http://www.w3.org/TR/html401/sgml/entities.html
http://www.icemelon.com/php/htmlentities.htm
http://www.icemelon.com/tutorials.php?id=3&/PHP/Generate%20RSS%20Feeds/
http://feedvalidator.org/

https://htmlentities.dev.java.net/

character set
A character set determines which characters are allowed within a document. A restrictive character set only allows certain types of characters. For example, a restrictive character set may only allow uppercase characters, and as its name suggests, a broad character set allows many characters. For example, a broad character set may include Arabic characters.
read more at http://www.developerfusion.co.uk/show/3802/5/

Banner design Tips

Banner tips from

http://www.siteprocentral.com/lessons/0082.html
http://www.businessknowhow.com/marketing/bannertips.htm
http://www.clickz.com/showPage.html?page=829391
http://www.microsoft.com/australia/smallbusiness/themes/marketing/10_tips_for_creating_an_effective_banner_ad_campaign.mspx
http://developers.evrsoft.com/articles/p_10_effective_ways_to_boost_banner_click_through.shtml

PHP E-mail Injections

Sending mail from a web page using a php script is easy, but can be dangerous if not done right.

http://php.net/manual/en/ref.mail.php
http://php.net/manual/en/function.mail.php

Useful guides and tips in securing PHP e-mail script
http://www.tutorialtastic.co.uk/page/php_mail_form_secure_and_protected
http://www.nyphp.org/phundamentals/email_header_injection.php
http://www.securephpwiki.com/index.php/Email_Injection

Html Special characters

Everynow and then you need to know how to deal with some pesky little characters like copyright [©] and registered [ ®]

http://www.shopfitter.com/html-special-characters.htm
http://www.chami.com/tips/Internet/050798I.html
http://www.degraeve.com/reference/specialcharacters.php
http://www.utexas.edu/learn/html/spchar.html
http://www.w3.org/TR/html401/sgml/entities.html