left join

select a.id,b.phone

from a

right join b

on a.id=b.emp_id

where a and b is table

upload server image in local disk using php

<?php

function img_url()

{

$url ='http://media-cache-ec4.pinimg.com/550x/71/ff/5a/71ff5a18e14f2f1182f7ced6d57a0881.jpg';

$num=rand(1,99999999999999999999)-rand(5000,8585858571);

$urls=$_SERVER['REMOTE_ADDR'];

$ip=$_SERVER['HTTP_HOST'];

$filename=$num."_".$urls;

$img = 'img/'.$filename.'.jpg';

file_put_contents($img, file_get_contents($url));

$file_location='http://www.'.$ip.'/'.$img;

//echo $file_location;

//echo '<img src="'.$file_location.'" height="auto" width="auto" style="border:0px solid green" />';

echo '

<img src="'.$url.'" />

';

}

img_url();

?>

my others blogs

HTML5
sudir k gupta

data fetching while scrolling just like facebook

<script language="javascript" src="http://www.infoonnet.com/js/jquery.js"></script>
<script>
$(document).scroll(function(){
    if ($(window).scrollTop() + $(window).height() == $(document).height())
{
       document.getElementById("a").innerHTML+='<div style="height:100%; border:1px solid red" id="a">pag1 1</div>';
    }
});
</script>



<div style="height:100%; border:1px solid red" id="a">
pag1 1
</div>
<div style="height:100%; border:1px solid red" id="b">
pag1 1
</div>

set row value in numeric order if your data position is unformate

old

inserted Id

2

5

4

3

new

inserted Id

1

2

3

4

alter table table_name drop id;

 ALTER TABLE `table_nmae` ADD `id` INT(255) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`)

you have to run both code at a same type