hello, please i need some help, I dont know what im doing wrong here. I keep getting this error and yesterday i wasn't getting it if anyone knows please help, thank you very much. the error is on line 561

PHP Code:

function CustomExpression($value,$data,$field,$table="")
{
    global $strTableName;
    if(!$table)
        $table=$strTableName;
    if($table=="Edrs Activos" && $field=="health_letter") 
    {
                                $value="";
                $msql1 = "select `Case #` from `Vital Info` where `Case #` = '".$data['Case #']."'";
                $nsql1 = mysql_query($msql1) or die(mysql_error());
                $mmsql1 = mysql_fetch_assoc($nsql1);
                $values = $mmsql1['Case #'];
                $msql = "SELECT `Tipo de Servicio` FROM `Vital Info` WHERE `Case #` = '".$data['Case #']."'";
                $nsql = mysql_query($msql) or die(mysql_error());
                $mmsql = mysql_fetch_assoc($nsql);
                $data = $mmsql['Tipo de Servicio'];
                $msql2 = "select `health_letter` from `Edrs Activos` where `Case #` = '".$data['Case #']."'"; //LINE 561
                $nsql2 = mysql_query($msql2) or die(mysql_error());
                $mmsql2 = mysql_fetch_assoc($nsql2);
                $done = $mmsql2['health_letter'];
                                            //$value = GetData($data,"health_letter", "");
                
            if ($data == "Traslado Guatemala")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>Incomplete</font></a>";
            else if ($data == "Traslado Salvador/Honduras/Nicaragua")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>Incomplete</font></a>";
            else if ($data == "")
                $value = "<strong><font color='green'>Check Vital Info</font>";
            else if ($done == "Done")
                $value = "<a href=\"health_letter_view.php?editid1=" .$values. "\" target=_blank>Done!</a>";
            else if ($done == "Pending")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>En Proceso</font></a>";
            else
                $value = "N/A";
            $record["health_letter_value"]=$value;
    } 


There aren't 561 lines of code there. Which one is 561?

I marked the line 561 there

$msql2 = "select `health_letter` from `Edrs Activos` where `Case #` = '".$data['Case #']."'"; //LINE 561

I'm guessing the problem occurs right before the line in question:

PHP Code:

$data = $mmsql['Tipo de Servicio']; 


Did you mean to overwrite $data? What is it set to after this line?

yes thank you very much it solved the error its not showing up anymore, i changed the variable name to $info but im trying to call the data here $done ant its suppose to display "Done" but its not working,

PHP Code:

function CustomExpression($value,$data,$field,$table="")
{
    global $strTableName;
    if(!$table)
        $table=$strTableName;
    if($table=="Edrs Activos" && $field=="health_letter") 
    {
                                $value="";
                $msql1 = "select `Case #` from `Vital Info` where `Case #` = '".$data['Case #']."'";
                $nsql1 = mysql_query($msql1) or die(mysql_error());
                $mmsql1 = mysql_fetch_assoc($nsql1);
                $values = $mmsql1['Case #'];
                $msql2 = "select `health_letter` from `Edrs Activos` where `Case #` = '".$data['Case #']."'";
                $nsql2 = mysql_query($msql2) or die(mysql_error());
                $mmsql2 = mysql_fetch_assoc($nsql2);
                $done = $mmsql2['health_letter'];
                $msql = "SELECT `Tipo de Servicio` FROM `Vital Info` WHERE `Case #` = '".$data['Case #']."'";
                $nsql = mysql_query($msql) or die(mysql_error());
                $mmsql = mysql_fetch_assoc($nsql);
                $info = $mmsql['Tipo de Servicio'];
                                            //$value = GetData($data,"health_letter", "");
                
            if ($info == "Traslado Guatemala")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>Incomplete</font></a>";
            else if ($info == "Traslado Salvador/Honduras/Nicaragua")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>Incomplete</font></a>";
            else if ($info == "")
                $value = "<strong><font color='green'>Check Vital Info</font>";
            else if ($done == "Done")
                $value = "<a href=\"health_letter_view.php?editid1=" .$values. "\" target=_blank>Done!</a>";
            else if ($done == "Pending")
                $value = "<a href=\"health_letter_edit.php?editid1=" .$values. "\" target=_blank><strong><font color='red'>En Proceso</font></a>";
            else
                $value = "N/A";
            $record["health_letter_value"]=$value;;
    } 


What exactly do you mean by 'its not working'. What is the value of $done after

PHP Code:

$done = $mmsql2['health_letter']; 


the value of $done is the value that is in the 'health_letter' field on the table `Edrs Activos` which theres only two options "Done" or "Pending" if the value is "Done" it should display "Done" with a link, if the value is "Pending" it should display "En Proceso" with a link, but its displaying "Incomplete" which is right too cause is displaying $info == "Traslado Guatemala". but i was hoping that even when $info is true $done takes priority because im doing the exact same thing in other table and its working fine.

If you want $done to 'take priority' you should check it before checking $info.

of course! that makes a lot of sense.. thank you very much! problem solved.