Apply for Zend Framework Certification Training

Mysql





<p>d</p>
                                    

$select_company = "select * , user_cities.name as city_name , user_states.name as state_name from user_company
        inner join user_states on user_company.state = user_states.id
        inner join user_cities on user_company.city = user_cities.id
        inner join user_location on user_company.location = user_location.location_id
        where user_company.data_type = 'company'";
        $mq_company = mysqli_query($conn,$select_company);
        $data_company = "<option value=''>Select company</option>";
        while($mfa_company = mysqli_fetch_assoc($mq_company)){
            $data_company .= "<option value=".$mfa_company['company_id'].">". $mfa_company['company_name'].'['.$mfa_company['state_name'].']['.$mfa_company['city_name'].']['.$mfa_company['location_name'].']'."</option>";  
        }
        
        echo $data_company;
        exit();

< SQL Injection Prevention in Codeigniter | webphplearn Digestion problum Solved in Homeopathy >



Ask a question



  • Question:
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question


Back to Top