How to get value using single field with multiple id?

Question

->When i call this code using ajax,it's not work proper

->Result is only for one category other category result not display,how can i solve this?

  $city_id=$_GET['id'];


//Get Area
$area_qry="SELECT * FROM tbl_area where city_id IN ('".$city_id."') ";


$area_res=mysql_query($area_qry);

        echo "<option value=''>-- Select City Area --</option>";

   while($area_row=mysql_fetch_array($area_res)){

            echo  "<option value='".$area_row['area_id']."'>".$area_row['area_name']."</option>";

        }

FYI, you are wide open to [SQL injections](http://stackoverflow.com/q/60174) — John Conde, Apr 04 '14 at 13:28

score 0 · Accepted Answer · answered Apr 04 '14 at 13:38

Solve myself,Here is updated code

$city_id=$_GET['id'];


//Get Area
$area_qry="SELECT * FROM tbl_area where city_id IN ($city_id) ";


$area_res=mysql_query($area_qry);

        echo "<option value=''>-- Select City Area --</option>";

   while($area_row=mysql_fetch_array($area_res)){

            echo  "<option value='".$area_row['area_id']."'>".$area_row['area_name']."</option>";

        }

How to get value using single field with multiple id?

1 Answers1