How to do this multiple IF statement in MySQL

How to do this multiple IF statement in MySQL

References

Reference NO 1

http://dev.mysql.com/doc/refman/5.0/en/if.html

Reference NO 2

http://stackoverflow.com/questions/15165192/how-to-do-this-multiple-if-statement-in-mysql

Reference NO 3

http://stackoverflow.com/questions/5008503/multiple-condition-in-a-single-if-in-select-query

Reference NO 4

http://komlenic.com/254/mysql-nested-if-in-select-queries/

Reference NO 5

http://my.safaribooksonline.com/book/databases/mysql/0596100892/blocks-conditional-statements-and-iterative-programming/mysqlspp-chp-4-sect-2

Reference NO 6

http://timmurphy.org/2009/08/13/inline-if-and-case-statements-in-mysql/

Reference NO 7

http://w3schools.invisionzone.com/index.php?showtopic=44100

Reference NO 8

http://www.sitepoint.com/forums/showthread.php?47728-MySQL-Multiple-Condition-in-WHERE-clause

C++ sign extension

C++ sign extension

References

Reference NO 1

http://stackoverflow.com/questions/15165417/c-sign-extension

Reference NO 2

http://en.wikipedia.org/wiki/Sign_extension

Reference NO 3

http://www.cs.umd.edu/class/sum2003/cmsc311/Notes/Data/signExt.html

Reference NO 4

http://bytes.com/topic/c/answers/213230-sign-extension

Reference NO 5

http://msdn.microsoft.com/en-us/library/windows/hardware/ff556892(v=vs.85).aspx

Reference NO 6

http://www.daniweb.com/software-development/computer-science/threads/152223/sign-extend-16-bit-to-32-bit

Reference NO 7

http://graphics.stanford.edu/~seander/bithacks.html

Reference NO 8

http://docs.oracle.com/cd/E19205-01/819-5267/bkbgp/index.html

MySQL count unique values in 2 fields

MySQL count unique values in 2 fields

References

Reference NO 1

http://stackoverflow.com/questions/15165661/mysql-count-unique-values-in-2-fields

Reference NO 2

http://stackoverflow.com/questions/12188027/mysql-select-distinct-multiple-columns

Reference NO 3

http://forums.devshed.com/mysql-help-4/using-count-distinct-column-2137.html

Reference NO 4

http://www.dbasupport.com/forums/showthread.php?11349-specifying-multiple-distinct-columns-in-a-COUNT()-function

Reference NO 5

http://forums.codewalkers.com/database-help-83/how-to-count-distinct-elements-mysql-83529.html

Reference NO 6

http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index1.html?page=2

Reference NO 7

http://www.daniweb.com/web-development/databases/mysql/threads/311910/count-and-print-unique-values-in-column

Reference NO 8

http://bugs.mysql.com/bug.php?id=21705

Examples of animation programmed in Objective-C [closed]

Examples of animation programmed in Objective-C [closed]

References

Reference NO 1

http://www.idev101.com/code/User_Interface/UIView/

Reference NO 2

http://developer.apple.com/library/ios/referencelibrary/GettingStarted/GS_Graphics_iPhone/

Reference NO 3

http://blog.shoguniphicus.com/2011/04/27/simple-frame-by-frame-animation-in-ios-part-2-objective-c/

Reference NO 4

http://www.vellios.com/2010/07/11/simple-iphone-animation-tutorial/

Reference NO 5

http://www.apeth.com/iOSBook/ch17.html

Reference NO 6

http://stackoverflow.com/questions/10860311/how-to-move-object-from-one-place-to-other-using-animation-in-iphone-application

Reference NO 7

http://bohemianpolymorph.wordpress.com/2011/01/30/combining-blocks-properties-and-animation-in-objective-c/

Reference NO 8

http://www.raywenderlich.com/tutorials

Will adding an instance of a class to a list copy the instance or just 'reference' it?

Will adding an instance of a class to a list copy the instance or just
'reference' it?

References

Reference NO 1

http://stackoverflow.com/questions/2106725/how-do-i-copy-an-instance-of-an-object

Reference NO 2

http://stackoverflow.com/questions/12101958/keep-track-of-instances-in-python

Reference NO 3

http://esug.org/data/Articles/Columns/EwingPapers/cvars&cinst_vars.pdf

Reference NO 4

http://docs.python.org/library/copy.html

Reference NO 5

http://phrogz.net/programmingruby/tut_classes.html

Reference NO 6

http://math.hws.edu/javanotes/c5/s2.html

Reference NO 7

http://en.wikipedia.org/wiki/Clone_(Java_method)

Reference NO 8

http://weka.sourceforge.net/doc.dev/weka/core/Instances.html

How to use MySQL instead of XML in this example.

How to use MySQL instead of XML in this example.

References

Reference NO 1

http://stackoverflow.com/questions/15185479/how-to-use-mysql-instead-of-xml-in-this-example

Reference NO 2

http://edutechwiki.unige.ch/en/PHP_-_MySQL_-_XML_tutorial_-_basics

Reference NO 3

http://www.mightywebdeveloper.com/coding/mysql-to-xml-php/

Reference NO 4

http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html

Reference NO 5

http://www.script-tutorials.com/autocomplete-with-php-jquery-mysql-and-xml/

Reference NO 6

http://www.kirupa.com/web/mysql_xml_php.htm

Reference NO 7

http://en.wikibooks.org/wiki/PHP_and_MySQL_Programming/XML_and_PHP

Reference NO 8

http://www.phpeveryday.com/articles/PHP-XML-Tutorial-P848.html

How can I create a reference for javascript library?

How can I create a reference for javascript library?

References

Reference NO 1

http://www.javascriptkit.com/javatutors/external.shtml

Reference NO 2

http://stackoverflow.com/questions/15185948/how-can-i-create-a-reference-for-javascript-library

Reference NO 3

http://backbonejs.org/

Reference NO 4

http://tokbox.com/opentok/v1/libraries/client/js/reference/overview.html

Reference NO 5

http://msdn.microsoft.com/en-us/library/vstudio/bb385682.aspx

Reference NO 6

https://developers.google.com/api-client-library/javascript/reference/referencedocs

Reference NO 7

http://arborjs.org/

Reference NO 8

http://d3js.org/