sqlite - Obtaining data from Database in php -

i trying fetch particular details database based on userid.

the problem is,instead of fetching data,it displaying

line 2 line 3{"posts":[]}. 

i using below code,

 <?php  @ob_start();  /* require user parameter */  if(isset($_get['user']) && intval($_get['user']))  { print "line 2"; /* soak in passed variable or set our own */ $number_of_posts = isset($_get['num']) ? intval($_get['num']) : 10; //10 default $format = strtolower($_get['format']) == 'json' ? 'json' : 'xml'; //xml default $user_id = intval($_get['user']); //no default  print "line 3";  /* connect db */ $link = mysql_connect('localhost','username','password') or die('cannot connect db'); mysql_select_db('database',$link) or die('cannot select db');             /* grab posts db */ $query = "select * tablename userid= '".$obj->{'userid'}."'";  $result = mysql_query($query,$link) or die('errant query:  '.$query);   $posts = array();  if(mysql_num_rows($result))  {                while($post = mysql_fetch_assoc($result))      {                            $posts[] = array('posts' =>$post);     } }  /* output in necessary format */ if($format == 'json')  {     header('content-type: application/json');     echo json_encode(array('posts'=>$posts));     exit(); } else  {     header('content-type: text/xml');     echo '<posts>';     foreach($posts $index => $post)      {         if(is_array($post))          {             foreach($post $key => $value)              {                 echo '<',$key,'>';                 if(is_array($value))                  {                     foreach($value $tag => $val)                      {                         echo '<',$tag,'>',htmlentities($val),'</',$tag,'>';                     }                 }                 echo '</',$key,'>';             }         }     }     echo '</posts>'; }  /* disconnect db */ @mysql_close($link); } ?>  

can 1 me?

$query = "select * tablename userid= '".$obj->{'userid'}."'"; 

should be:

$query = "select * tablename userid= '".mysql_real_escape_string(userid)."'"; 

there no $obj variable in script.