Hi, i've found a very nice script to access the mysql database. Now I want to use this script. I've adapted some php to make it working. Here's the PHP:

This is the android script:

2. //package com.list;
3. //import java.io.BufferedReader;
4. //import java.io.InputStream;
5. //import java.io.InputStreamReader;
6. import java.util.ArrayList;
7. import org.apache.http.HttpEntity;
8. import org.apache.http.HttpResponse;
9. import org.apache.http.NameValuePair;
10. import org.apache.http.client.HttpClient;
11. import org.apache.http.client.entity.UrlEncodedFormEntity;
12. import org.apache.http.client.methods.HttpPost;
13. import org.apache.http.impl.client.DefaultHttpClient;
14. import org.json.JSONArray;
15. import org.json.JSONException;
16. import org.json.JSONObject;
17. import org.apache.http.message.BasicNameValuePair;
18. import android.app.ListActivity;
19. import android.net.ParseException;
20. import android.os.Bundle;
21. import android.util.Log;
22. import android.widget.Toast;
23. import java.io.BufferedReader;
24. import java.io.InputStreamReader.*;
25. 
    
26. void mysqlDB() {
27. String result = "";
28. //the year data to send
29. ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
30. nameValuePairs.add(new BasicNameValuePair("year", "1980"));
31. 
    
32. 
    
33.   //http post
34.   try {
35.     HttpClient httpclient = new DefaultHttpClient();
36.     HttpPost httppost = new HttpPost("http://yourhost/read.PHP");
37.     httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
38.     HttpResponse response = httpclient.execute(httppost);
39.     HttpEntity entity = response.getEntity();
40.     InputStream is = entity.getContent();
41.   } 
42.   catch(Exception e) {
43.     Log.e("log_tag", "Error in http connection "+e.toString());
44.   }
45.   //convert response to string
46.   try {
47.     
48.     BufferedReader reader = new BufferedReader(new InputStreamReader(is, "iso-8859-1"), 8);
49.     StringBuilder sb = new StringBuilder();
50.     String line = null;
51.     while ( (line = reader.readLine ()) != null) {
52.       sb.append(line + "\n");
53.     }
54.     is.close();
55. 
    
56.     result=sb.toString();
57.   } 
58.   catch(Exception e) {
59.     Log.e("log_tag", "Error converting result "+e.toString());
60.   }
61. 
    
62.   //parse json data
63.   try {
64.     JSONArray jArray = new JSONArray(result);
65.     for (int i=0;i<jArray.length();i++) {
66.       JSONObject json_data = jArray.getJSONObject(i);
67.       Log.i("log_tag", "id: "+json_data.getString("id")+
68.         ", longitude: "+json_data.getString("lon")+
69.         ", latitude: "+json_data.getString("lat")+
70.         ", concept: "+json_data.getString("concept")
71.         );
72.     }
73.   }
74. 
    
75. catch(JSONException e) {
76.   Log.e("log_tag", "Error parsing data "+e.toString());
77. }
78. }

And i get a error at this part:

1. BufferedReader reader = new BufferedReader(new InputStreamReader(is, "iso-8859-1"), 8);