How to find second highest salary in MySQL

if you have MySQL table like below image if you want to fetch second highest salary of employee following query will be useful for you. select sal from emp group by sal order by sal desc Limit 1,1 your output will be like below image if you want to fetch all employee which have second highest salary following query will be useful for you. select * from emp where sal=(select...

Read More »

How to delete all inside folder

This function is useful to delete all inner folder of given path of folder. Lets explain in example: if you have folder which name is user_1  and user_1 have lots of folder like (my_album, my_profile,friends_photo etc.) if you want to delete folder (my_album, my_profile,friends_photo etc.) call function like belew <?php deleteDirectory($dir); // $dir = path of user_1 folder ?> function deleteDirectory($dir) { if (!file_exists($dir)) return true; if (!is_dir($dir)...

Read More »

Date after 10 days

$your_date = '2012-07-21'; $date_after_ten_days = date("Y-m-d",strtotime(date("Y-m-d", strtotime($your_date)) . " +10 day")); echo $date_after_ten_days; //output 2012-07-...

Read More »