Help on how to select in stored procedure

[ludah]

Can someone help meon this

function get_country_by_id($dbc,$country_id){
    $sql = "CALL SelectCountryById('$country_id')";
    $q = mysqli_query($dbc,$sql);
    $data = mysqli_fetch_array($q);
    return $data;
}

$client_country_info = get_country_by_id($dbc,$client_info['country']);

echo $client_country_info['country_name'];

CREATE DEFINER=`root`@`localhost` PROCEDURE `SelectCountryById`(IN country_id INT(11))
BEGIN
    SELECT * FROM country_tbl WHERE id = country_id;
  END;