Member Avatar

Dear All help me pls.. i am unable to fetch result in dropdown from database... connection.php $db = new PDO("mysql:host=localhost;dbname=test","root",""); ----------------------------------------- Add_student.php <tr> <th>City</th> <td><select name="st_city" id="st_city"> <?php echo get_option_list("city","City_id","City_name"); ?> </select> </td></tr> ----------------------------------------- functions.php function get_option_list($table,$id,$name) { $SQL=$db->query("SELECT * FROM ".$table." ORDER BY". $name); $get_list="<option value=0>Please Select</option>"; while($row=$SQL->fetch(PDO::FETCh_ASSOC)) { } return $get_list; }

Member Avatar
0
9

The End.