i am creating a drop box list with php and mysql to select data from the database . table name : specialization fields: specialization_id, specialization_name function ================ function specializationQuery() { if(isset($_POST['username'])) { $specialization = mysql_real_escape_string($_POST['specialization']); $specData = mysql_query("SELECT specialization_name FROM specialization WHERE specialization_id = '$specialization'"); while($recordJob = mysql_fetch_array($specData)) { echo'<option value="' . $recordJob['specialization_name'] . '">' . $recordJob['specialization_name'] . '</option>'; } } } i want that in the user table iit must contain the **specialization _id** but this selection from the specialization table did not work can anyone help me ???
