Jump to content

mysql select query + php


lebdev

Recommended Posts

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 ???

 

Link to comment
https://forums.phpfreaks.com/topic/277138-mysql-select-query-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.