Title: sql query not working with arabic names
Last modified: August 20, 2016

---

# sql query not working with arabic names

 *  Resolved [was955](https://wordpress.org/support/users/was955/)
 * (@was955)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-query-not-working-with-arabic-names/)
 * hi
    i have search form in a theme
 * it search cars
 * i have this part of code
 *     ```
       $manufacturer = get_option('wp_manufacturer_level1');
       $arr_manufacturer = explode("\n", $manufacturer);
       foreach ($arr_manufacturer as $item) {
       $item = trim($item);
       	$countmanufacturers = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts p, $wpdb->postmeta p1
                   WHERE p.post_status = 'publish' AND p.ID = p1.post_id AND p1.meta_key = 'manufacturer_level1_value' AND p1.meta_value = '$item'");
       		if ($countmanufacturers > 0) {
       			$manufactureroptions = $manufactureroptions . "<option value='" . $item . "'>" . $item . " (" . $countmanufacturers . ")</option>";
       		}
       }
       ```
   
 * the problem here is with arabic names it stop counting cause there is a problem
   with sql query which i am not familiar with can some one help me?

Viewing 1 replies (of 1 total)

 *  Thread Starter [was955](https://wordpress.org/support/users/was955/)
 * (@was955)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-query-not-working-with-arabic-names/#post-3333494)
 * well thank you everyone. it is working but there was misunderstood in the data
   input.

Viewing 1 replies (of 1 total)

The topic ‘sql query not working with arabic names’ is closed to new replies.

## Tags

 * [cars](https://wordpress.org/support/topic-tag/cars/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 1 reply
 * 1 participant
 * Last reply from: [was955](https://wordpress.org/support/users/was955/)
 * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/sql-query-not-working-with-arabic-names/#post-3333494)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics