لیست شهر ها و نمایندگی ها

من الان از سمت اندروید مثلا تهران رو می فرستم سمت سرور : اینجا به چه شکل انجام میشه ؟ بعد WHERE به چه صورته؟

 function read(){
    $connection = connectToDatabase();
    $city= $_REQUEST['city'];
    $result = mysqli_query($connection,  "SELECT * FROM  reseller_list WHERE city='$city' GROUP BY city");
    $output = array();
    while($row = mysqli_fetch_array($result)) {
        $record = array();
        $record['id'] = $row['id'];
        $record['name'] = $row['name'];
        
        $output[] = $record;
    }

خوب من تا اینجاشو درست کردم فقط چطری کوئری به دومی بزنم رو نمی دونم .

 
		loadSpinnerData();
		loadSpinnerData2();

		 label = spinner1.getSelectedItem().toString();

	}

	private void loadSpinnerData() {

		DataBaseConnection db = new DataBaseConnection(this, "database", 5);

		labels = new ArrayList<String>();

		String selectQuery = "SELECT  * FROM province";

		SQLiteDatabase database = db.getReadableDatabase();
		Cursor cursor = database.rawQuery(selectQuery, null);

		while (cursor.moveToNext()) {
			try {

				labels.add(cursor.getString(cursor.getColumnIndex("namep")));

			} catch (Exception e) {

			}

		}

		cursor.close();
		database.close();

		ArrayAdapter<String> dataAdapter = new ArrayAdapter<String>(this,
				android.R.layout.simple_spinner_item, labels);

		dataAdapter
				.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

		spinner1.setAdapter(dataAdapter);
	}



	private void loadSpinnerData2() {

		DataBaseConnection db = new DataBaseConnection(this, "database", 5);

		labels2 = new ArrayList<String>();

		String selectQuery = "SELECT  * FROM city";

		SQLiteDatabase database = db.getReadableDatabase();
		Cursor cursor = database.rawQuery(selectQuery, null);

		while (cursor.moveToNext()) {
			try {

				labels2.add(cursor.getString(cursor.getColumnIndex("name")));

			} catch (Exception e) {

			}

		}

		cursor.close();
		db.close();

		ArrayAdapter<String> dataAdapter = new ArrayAdapter<String>(this,
				android.R.layout.simple_spinner_item, labels2);

		dataAdapter
				.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

		spinner2.setAdapter(dataAdapter);
	}