How to convert timestamp to date in MYSQL with where clause?

SELECT * , DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat
FROM phpfox_feed
WHERE DATE( FROM_UNIXTIME( `time_stamp` ) ) = '2012-09-05'

How to convert timestamp to date in MYSQL?

MYSQL:

SELECT DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat FROM users

 

OUTPUT:

2012-09-06

how to check element visibility in jquery?

example of element exists and it’s not visible

<div id="test">
  <div id="test_1" style="display:none">
    Hello World!
  </div>
</div>


jQuery code:
  if ($('#test_1:visible').length > 0)
{
         alert('the element is visible');
}
    else
{
         alert('the element is not visible');
}

how to replace & or special characters in javascript?

//if  value of catnm='art & jewllery';

//then i want need to replace "&".

//because when i will try to post data using jquery then jquery know this is query string.....so i want to need  to replace "&"  using "URL ENCODED CHARACTERS"

//so,see below example

var catnm=document.getElementById('catnm').value;

var cat_re=catnm.replace('&','%26');

OUTPUT 

In Javascript alert box  : art %26 jewllery

In html format(in web browser )  : art & jewllery

Please refer below website for URL Encode Characters

http://www.degraeve.com/reference/urlencoding.php

http://www.w3schools.com/tags/ref_urlencode.asp

how to validate multiple select box with jquery?

$("#form").validate({
rules:{
"select_esp[]": "required"
},
messages:{
"select_esp[]": "Select this"
}
});

 

How to enable/disable element in Javascript

If u want to enable or disable any HTML element using javascript in asp.net/php u can use the following code,

document.getelementbyid('nm').disabled='disabled' ;


and the below code will enable the element,

document.getelementbyid('nm').disabled='';

Sql Joins