<?php
if (isset($_POST['variable'])){
$bd_host = "BEREESSEC-PC\SQLEXPRESS";
$bd_usuario = "sa";
$bd_password = "123456";
$bd_base = "SERCAP";
$con = mssql_connect($bd_host, $bd_usuario, $bd_password);
mssql_select_db($bd_base, $con);
//consulta todos los empleados
$id=$_POST['txtId_matriz'];
$sql=mssql_query("SELECT * FROM TMatrizAdoctrinamientoEncabezado where Id_matriz='$id'",$con);
while($row = mssql_fetch_array($sql)){
$revision=$row['Revision'];
}
}
?>
<html>
<form id='forma' method="post" action="formulario.php">
<table>
<tr><td><input type="text" name="txtId_matriz" onKeyPress="if (event.keyCode==13){if(this.value!='') document.getElementById('forma').submit();}"/></td></tr>
<tr><td><input type="text" name="Revision" value="<?php if(isset($revision)) echo $revision; ?>"/></td></tr>
</table>
</form>
</html>