Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "
- SELECT
- TOP 5
- mult.sequencial,
- mult.derivacao,
- mult.paciente,
- mult.internacao,
- convert(varchar,mult.datahora,120) as datahora,
- pro.nome as profissao,
- prof.nome as profissional,
- mult.evolucao,
- mult.usuario,
- convert(varchar,mult.data,120) as data,
- simb.descricao
- FROM
- tblEvolucaoMultidisciplinar mult
- INNER JOIN tblProfissao pro ON pro.profissao = mult.profissao
- INNER JOIN tblProfissionais prof ON prof.profissional = mult.profissional
- INNER JOIN tblSimbolos simb ON simb.simbolo = mult.finalidade and
- tabela = 'tblEvolucaoMultidisciplinar' and
- campo = 'Finalidade'
- WHERE
- paciente = '149980' and
- internacao = '1' and
- fechado = '1' and
- finalidade = 2 and
- excluido = 0
- ORDER BY datahora DESC
- ";
- $host = "x";
- $user = "x";
- $pass = "x";
- $conexao = mssql_connect($host,$user,$pass);
- $result = mssql_query($sql,$conexao);
- $fetchArrays = mssql_fetch_array($result);
- var_dump($fetchArrays);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement