Code Scraps

#PHP/SQL
//Quick DB search/Replace//
UPDATE table_name SET column = replace(column, 'old string','new string');
//Send mail on failure//
mail('Donnie.A@live.com', 'WEB FORM ERROR ON #WEBSITE NAME HERE#', 'Details:'."\n".'To: '.$to."\n".'Headers: '.$headers."\n".'Message :'.$message);
//Quick(but not perfect) email validation//
filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)
//Overkill hashing
$superhash = sha1(substr(sha1($email),0, -10).substr(sha1(time()),0, -10).substr(sha1($password),0, -10));


#Javascript


#CSS
//CSS Drop Shadow(All Browsers)//
    -moz-box-shadow: 3px 3px 4px #000;
    -webkit-box-shadow: 3px 3px 4px #000;
    box-shadow: 3px 3px 4px #000;
    /* For IE 8 */
    -ms-filter: "progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#000000')";
    /* For IE 5.5 - 7 */
    filter: progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#000000');

//Little somthing
SELECT *
  FROM MyTable
  WHERE [dateColumn] > '3/1/2009' AND [dateColumn] <= DATEADD(day,'3/31/2009',1)
                 --make it inclusive for a datetime type
    AND DATEPART(hh,[dateColumn]) >= 6 AND DATEPART(hh,[dateColumn]) <= 22
                 -- gets the hour of the day from the datetime
    AND DATEPART(dw,[dateColumn]) >= 3 AND DATEPART(dw,[dateColumn]) <= 5
                 -- gets the day of the week from the datetime