<script type="text/javascript"> function PrintWindow(){ window.print(); CheckWindowState(); } function CheckWindowState(){ if(document.readyState=="complete"){ window.close(); }else{ setTimeout("CheckWindowState()", 2000) } } PrintWindow(); </script>

The readyState property indicates the current state of the XML document.

This property is read-only and returns one of the following values indicating the instantiation and download state of the XML document.

• LOADING
  loading in progress; reading persisted properties but not yet started parsing data. For purposes of the standard readyState definitions, data should be considered equivalent to BLOB properties.
• LOADED
  reading of persisted properties completed; reading and parsing data, but the object model is not yet available.
• INTERACTIVE
  some data has been read and parsed, and the object model is available on the partially received data set. The object model at this stage is read-only.
• COMPLETED
  the document has been completely loaded, successfully or unsuccessfully.

This property is a Microsoft extension to the W3C DOM.

Include the Javascript library, by putting a link to it in the HEAD of your page, like so:

<script src="sorttable.js"></script>

Mark your table as a sortable one by giving it a class of "sortable":

<table class="sortable">

Click on the read more link for the Javascript file.

This little query updates a search string and replaces it with a replace string.

Find and replace query for mysql 

 UPDATE `table_name` SET `field_name` = replace(`field_name`, 'search_term' , 'replace_term' )