I make a form where I want to modify some data that is inserted in my DB , but I have a problem with two fields because it does not bring them to me. form that is, when clicking on the edit icon, fill in the form with the data that is stored in my BD and that belong to that record , but I have two fields that do not show me the corresponding data are idctg_turno and date_nac , in my BD I have foreign keys.
Structure of my worker table
id_Control Primaria int(10)
nombre varchar(30)
ap_paterno varchar(30)
ap_materno varchar(30)
NSS varchar(30)
CURP varchar(30)
RFC varchar(30)
fecha_nac date
id_area Índice int(10)
idctg_turno Índice int(10)
idctg_empresa Índice int(10)
id_nomina Índice int(11)
id_activo Índice int(11)
This is my edit form code
<?php
$puesto =mysqli_query($con, "select * from puesto");
$area =mysqli_query($con, "select * from area");
$turno =mysqli_query($con, "select * from ctg_turno");
$empresa =mysqli_query($con, "select * from empresa");
$nomina =mysqli_query($con, "select * from nomina");
$activo =mysqli_query($con, "select * from activo");
?>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Fecha Nacimiento<span class="required">*</span></label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="date" name="fecha_nac" class="form-control" placeholder="fecha_nac" id="mod_fecha_nac" required>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Turno
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<select class="form-control" name="idctg_turno" required id="mod_idctg_turno">
<option selected="" value="">-- Selecciona --</option>
<?php foreach($turno as $p):?>
<option value="<?php echo $p['idctg_turno']; ?>"><?php echo $p['descripcion']; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>This is where I call the data by "modal"
function obtener_datos(id_Control){
var description = $("#description"+id_Control).val();
var nombre = $("#nombre"+id_Control).val();
var ap_paterno = $("#ap_paterno"+id_Control).val();
var ap_materno = $("#ap_materno"+id_Control).val();
var NSS = $("#NSS"+id_Control).val();
var CURP = $("#CURP"+id_Control).val();
var RFC = $("#RFC"+id_Control).val();
var fecha_nac = $("#fecha_nac"+id_Control).val();
var id_puesto = $("#id_puesto"+id_Control).val();
var id_area = $("#id_area"+id_Control).val();
var idctg_turno = $("#idctg_turno"+id_Control).val();
var idctg_empresa = $("#idctg_empresa"+id_Control).val();
var id_nomina = $("#id_nomina"+id_Control).val();
var id_activo = $("#id_activo"+id_Control).val();
$("#mod_id_Control").val(id_Control);
$("#mod_nombre").val(nombre);
$("#mod_ap_paterno").val(ap_paterno);
$("#mod_ap_materno").val(ap_materno);
$("#mod_NSS").val(NSS);
$("#mod_CURP").val(NSS);
$("#mod_RFC").val(RFC);
$("#mod_fecha_nac").val(fecha_nac);
$("#mod_id_puesto").val(id_puesto);
$("#mod_id_area").val(id_area);
$("#mod_idctg_turno").val(idctg_turno);
$("#mod_idctg_empresa").val(idctg_empresa);
$("#mod_id_nomina").val(id_nomina);
$("#mod_id_activo").val(id_activo);
}Structure ctg_turno table
idctg_turno PrimariaÍndice int(10)
descripcion varchar(20)
Jornada int(11)