问从MySql到PostgreSql

EN

function f_nome($e_tipo, $db_table)
{
    $thisyear = date('Y');
    $db = pg_connect("host=localhost port=5432 dbname=**** user=yyyyy");
    $result = pg_query($db,"SELECT  MIN(data) AS earliest, nome, data, saldo, id
    FROM $db_table 
    WHERE tipo = '$e_tipo' AND year ='$thisyear'
    GROUP BY nome, data, saldo, id
    ORDER BY earliest");
    $row_cnt = pg_num_rows($result);
    while ($row = pg_fetch_array($result))
      {$z_nome=$row['nome'];
      echo "<option>$z_nome</option>";} 
pg_close($db);
return $z_nome; 
}