[SOLVED]selecting all cityArea under a city is not working using custom query

[osclassLover]

i am using modern, theme

there i have stored cityArea under a city.

when i selecting the all area under a city its giving only one area only, i dont know why...

for example:

i have list 3 area under a city

sample 1, sample 2 , sample 3( cityId for this areas are same (50000) )

i use the following custom query inside functions.php file.

$conn = getConnection();
/
      $area = $conn->osc_dbFetchResult("SELECT * FROM `oc_t_city_area`WHERE `fk_i_city_id` =50000");
           print_r($area);
 but it prints the sample 1 only in the result, i dont know why

pls help me someone...thanks...

[serjuc11111]

use:

foreach($area as $area2)
echo $area2['s_name']; // or your field needed!

[osclassLover]

http://forums.osclass.org/modern/selecting-all-cityarea-under-a-city-is-not-working-using-custom-query/