问PHP mysql获取行代码以查找另一个表项中的变量值

EN

$rs = mysql_query("select
    type,
    ref,
    date,
    owner   

    from documents where account=" . quote($currentaccount) . " and owner=" .      quote($owner) . " and type like 'CR%' order by entered desc");
echo '<table class="data" width="97%">';
while ($r = mysql_fetch_row($rs))
{
    $i = 0;
    echo '<tr>';

    $type = $r[$i++];
    echo '<td>';
    echo esc($type);
    echo '</td>';

    $ref = $r[$i++];
    echo '<td>';
    echo '<a href="download.php?type=' . escurl($type) . '&ref=' . escurl($ref) . '">' .  esc($ref) . '</a>';
    echo '</td>';

    $s = $r[$i++];
    echo '<td>';
    echo strdate($s);
    echo '</td>';

    $s = $r[$i++];
    echo '<td align="right">';
    echo blankzero($s);
    echo '</td>';

    echo '</tr>';
}

echo '</table>';

require '../inc/end.php';