how to change all to UPPERCASE in an input box

for a text box, here's the code.

<input type="text" onblur="this.value=this.value.toUpperCase()" name="" placeholder="all of this will be uppercase" />

How to update mysql table ignoring the duplicate fields that are already present

here's how you do it.

INSERT INTO thetable (pageid, name, somefield)
VALUES (1, "foo", "first")
ON DUPLICATE KEY UPDATE (somefield = 'first')

taken from

http://stackoverflow.com/questions/2219786/best-way-to-avoid-duplicate-entry-into-mysql-database

Update one Mysql table with results from another table on a different database

here's how you update one table with results from another database query.


UPDATE
target_database.target_table A                                //database to be updated-target
INNER JOIN source_database.source_table B     //join source database to target
ON B.ProductID = A.ProductID                          //join fields
SET A.Markup = B.Markup                                         //fields to be updated

how to find duplicates in two columns of mysql database table

any one column can have duplicates. but both columns together are unique. this is how you find duplicates

select   columnA,
         columnB,
         count(*)
from     table_name
group by columnA,
         columnB
having   count(*) > 1

how to get the no of days in the current month in php

this function will get the days in the current month

date('t');

how to use the switch statement in php

switch statement can be extremely useful in complex situations.

switch($variable)
{
case "a":
        // run the code if $variable =  a .
break;
case "b":
        // run the code if $variable = b .
break;
case "c":
        // run the code if $variable = c .
break;
default:
        // run the code if $variable is not equal to either a,b or c
}

check existing mysql triggers

SELECT * FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'database_name';

OR

SHOW TRIGGERS;