lebdev Posted April 19, 2013 Share Posted April 19, 2013 i am creating a drop box list with php and mysql to select data from the database . table name : specializationfields: specialization_id, specialization_namefunction================ 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 ??? Link to comment https://forums.phpfreaks.com/topic/277138-mysql-select-query-php/ Share on other sites More sharing options...
requinix Posted April 19, 2013 Share Posted April 19, 2013 None of that code has anything to do with a "user" table... Link to comment https://forums.phpfreaks.com/topic/277138-mysql-select-query-php/#findComment-1425831 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.