# ' . $usuario_lg .' ' . $fecha_lg .' ' . $accion_lg . ' ' . $ordenador_lg . ' ' . $detalles_lg . ' '; $nr = 1; $sqlHistorial = "SELECT VEHICULOS_HISTORIAL.*,VEHICULOS_LITERALES.*, DESCRIPCION_$lg AS DESCRIPCION_LG FROM VEHICULOS_HISTORIAL,VEHICULOS_LITERALES WHERE VEHICULOS_LITERALES.CODIGO = VEHICULOS_HISTORIAL.ACCION AND VEHICULOS_LITERALES.TIPO = 'TIP_TRA' AND VEHICULOS_HISTORIAL.VEHICULO = ? ORDER BY VEHICULOS_HISTORIAL.FECHA DESC"; $stmt = $con->prepare($sqlHistorial); $stmt->bind_param('i',$codigo); $stmt->execute(); $res = $stmt->get_result(); while($filaHistorial = $res->fetch_array()){ echo ' '. $nr++ .' ' . ucwords($filaHistorial['USUARIO']) . ' ' . date('H:i:s d/m/Y',strtotime($filaHistorial['FECHA'])) . ' ' . $filaHistorial['DESCRIPCION_LG'] . ' ' . $filaHistorial['ORDENADOR'] . ' '; if($filaHistorial['DETALLE'] == ""){ echo " $gestion_interna_lg"; }else{ echo '

' . $filaHistorial['DETALLE'] . '

'; } echo ' '; } echo '';