en consulta_evaluacion.php pongo
Código PHP:
<?php
$socio = $_POST['valor_text'];
$conec1=mysql_connect("localhost","admin","");
mysql_select_db("db",$conec1);
$queEmp7 = "SELECT hccf.cf_861 as obs FROM vtiger_historiaclinicacf hccf JOIN
vtiger_historiaclinica hc ON hccf.historiaclinicaid=hc.historiaclinicaid JOIN vtiger_contactscf ccf ON hc.linkto=ccf.contactid
join vtiger_crmentity crm on crm.crmid=ccf.contactid
WHERE ccf.cf_644='$socio' and crm.deleted='0'";
$resEmp7 = mysql_query($queEmp7,$conec1)or die(mysql_error());
$totEmp7 = mysql_num_rows($resEmp7);
$rowemp7 = mysql_fetch_assoc($resEmp7);
$obs=$rowemp7['obs'];
echo($obs);
?>