Conecar no Mysql erro :

1.
      CREATE TABLE `people` (
   2.
      `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   3.
      `name` VARCHAR( 100 ) NOT NULL ,
   4.
      `sex` BOOL NOT NULL DEFAULT '1',
   5.
      `birthyear` INT NOT NULL
   6.
      )

1.
      <?php
   2.
      mysql_connect("host","username","password");
   3.
      mysql_select_db("PeopleData");
   4.
       
   5.
      $q=mysql_query("SELECT * FROM people WHERE birthyear>'".$_REQUEST['year']."'");
   6.
      while($e=mysql_fetch_assoc($q))
   7.
              $output[]=$e;
   8.
       
   9.
      print(json_encode($output));
  10.
       
  11.
      mysql_close();
  12.
      ?>

1.
      String result = "";
   2.
      //the year data to send
   3.
      ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
   4.
      nameValuePairs.add(new BasicNameValuePair("year","1980"));
   5.
       
   6.
      //http post
   7.
      try{
   8.
              HttpClient httpclient = new DefaultHttpClient();
   9.
              HttpPost httppost = new HttpPost("http://example.com/getAllPeopleBornAfter.php");
  10.
              httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
  11.
              HttpResponse response = httpclient.execute(httppost);
  12.
              HttpEntity entity = response.getEntity();
  13.
              InputStream is = entity.getContent();
  14.
      }catch(Exception e){
  15.
              Log.e("log_tag", "Error in http connection "+e.toString());
  16.
      }
  17.
      //convert response to string
  18.
      try{
  19.
              BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
  20.
              StringBuilder sb = new StringBuilder();
  21.
              String line = null;
  22.
              while ((line = reader.readLine()) != null) {
  23.
                      sb.append(line + "\n");
  24.
              }
  25.
              is.close();
  26.
       
  27.
              result=sb.toString();
  28.
      }catch(Exception e){
  29.
              Log.e("log_tag", "Error converting result "+e.toString());
  30.
      }
  31.
       
  32.
      //parse json data
  33.
      try{
  34.
              JSONArray jArray = new JSONArray(result);
  35.
              for(int i=0;i<jArray.length();i++){
  36.
                      JSONObject json_data = jArray.getJSONObject(i);
  37.
                      Log.i("log_tag","id: "+json_data.getInt("id")+
  38.
                              ", name: "+json_data.getString("name")+
  39.
                              ", sex: "+json_data.getInt("sex")+
  40.
                              ", birthyear: "+json_data.getInt("birthyear")
  41.
                      );
  42.
              }
  43.
      }
  44.
      }catch(JSONException e){
  45.
              Log.e("log_tag", "Error parsing data "+e.toString());
  46.
      }