Android querying external MySQL database
<p>I had some problem understanding the following line of code. What exactly does it do and how does it help me query the database from android </p>

<pre><code>$q=mysql_query("SELECT * FROM people WHERE birthyear&gt;'".$_REQUEST['year']."'");
while($e=mysql_fetch_assoc($q))
    $output[]=$e;
print(json_encode($output));
</code></pre>

<p>I know the initial part of it means select every record from table people where birthyear...</p>

<p>But after that I get confused. I am calling this php function from android using http post</p>

<pre><code>ArrayList&lt;NameValuePair&gt; nameValuePairs = new ArrayList&lt;NameValuePair&gt;();
nameValuePairs.add(new BasicNameValuePair("year","1980")); 
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://10.0.2.2/retrieve.php");
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
HttpResponse response = httpclient.execute(httppost); 
HttpEntity entity = response.getEntity();
is = entity.getContent();
</code></pre>

<p>Where is an input stream. Can someone help me out? </p>
