DENIS É POSSIVEL Q PELO phpMyAdmin FUNCIONAR O SCRIPT E POR EXEMPLO POR UM PG PHP NÃO ? POIS CRIEI O SEGUINTE SCRIPT: [font="Lucida Sans Unicode"]<html>
<head>
<link rel=stylesheet href="style.css" type="text/css"></head>
<style>
td {background: #fff;}
</style>
</head>[/font]
[font="Lucida Sans Unicode"]<body style="padding: 0;">
<table border="1" cellspacing="0" width="100%" bordercolordark="white" bordercolorlight="black">
<tr height="30" style="background-color: #EDEDED;">
<td width="10%" bgcolor="#EDEDED" align="center" valign="middle">DATA</td>
<td width="05%" bgcolor="#EDEDED" align="center" valign="middle">T.O.</td>
<td width="10%" bgcolor="#EDEDED" align="left" valign="middle">N.DOC.</td>
<td width="05%" bgcolor="#EDEDED" align="center" valign="middle">TR.</td>
<td width="05%" bgcolor="#EDEDED" align="left" valign="middle">CODIGO</td>
<td width="20%" bgcolor="#EDEDED" align="left" valign="middle">CLIENTE/FORNECEDOR</td>
<td width="10%" bgcolor="#EDEDED" align="right" valign="middle">preço</td>
<td width="10%" bgcolor="#EDEDED" align="right" valign="middle">C.M.P.</td>
<td width="10%" bgcolor="#EDEDED" align="right" valign="middle">QTD.</td>
<td width="05%" bgcolor="#EDEDED" align="center" valign="middle">T</td>
<td width="10%" bgcolor="#EDEDED" align="right" valign="middle">SALDO</td>
</tr>
<?
$codigo = $_REQUEST["codigo"];
$empresa= $_REQUEST["empresa"];
$local = $_REQUEST["local"];
$con=mysql_connect("localhost","root","");
mysql_select_db('sistema_'.$empresa,$con);
$sql ='CREATE TEMPORARY TABLE TMP SELECT Codigo, RazaoSocial FROM PA0022;'
.'INSERT INTO TMP SELECT Codigo, RazaoSocial FROM PA0042;'
.'SELECT DATE_FORMAT(DtMovimento,\'%d/%m/%y\'), CodOperacao, NDocumento, Transacao, M.CodCliFornec, TMP.RazaoSocial,'
.'FORMAT(preço,2), FORMAT(CtMedPonderado,2), FORMAT(QtMovimentada,3), FORMAT(Saldo,3)'
.'FROM PA0111 M INNER JOIN TMP ON TMP.COdigo = M.CodCliFornec WHERE Codigo = \'$codigo\' AND NLocal = \'$local\' Order by Transacao asc;';
$res=mysql_query($sql) or die ("erro na query ".mysql_error());
$col=mysql_num_fields($res);
$num=mysql_num_rows($res);
/* não USAR
SELECT DATE_FORMAT(DtMovimento,'%d/%m/%y'),CodOperacao,NDocumento,Transacao,
CodCliFornec,
FORMAT(preço,2),FORMAT(CtMedPonderado,2),FORMAT(QtMovimentada,3),FORMAT(Saldo,3)
from PA0111
where codigo ='$codigo' and Nlocal = '$local' order by Transacao asc"; */[/font]
[font="Lucida Sans Unicode"] for ($linha=0;$linha<$num;$linha++){
echo "<tr height=\"20\">";
echo "<td align=\"center\" valign=\"bottom\">".mysql_result($res,$linha,0)/*DATA */."</td>";
echo "<td align=\"center\" valign=\"bottom\">".mysql_result($res,$linha,1)/*COPER*/."</td>";
echo "<td align=\"left\" valign=\"bottom\">".mysql_result($res,$linha,2)/* N F */."</td>";
echo "<td align=\"center\" valign=\"bottom\">".mysql_result($res,$linha,3)/* T R */."</td>";
echo "<td align=\"left\" valign=\"bottom\">".mysql_result($res,$linha,4)/* COD */."</td>";
echo "<td align=\"right\" valign=\"bottom\">".mysql_result($res,$linha,5)/*RAZAO*/."</td>";
echo "<td align=\"right\" valign=\"bottom\">".mysql_result($res,$linha,6)/* P R */."</td>";
echo "<td align=\"right\" valign=\"bottom\">".mysql_result($res,$linha,7)/*C M P*/."</td>";
echo "<td align=\"right\" valign=\"bottom\">".mysql_result($res,$linha,8)/* QTD */."</td>";
echo "<td align=\"center\" valign=\"bottom\">";
if (mysql_result($res,$linha,1) >= 50) /* T */
{echo "S";}
else
{echo "E";}
echo "</td>";
echo "<td align=\"right\" valign=\"bottom\">".mysql_result($res,$linha,9)/* SLD */."</td>";
echo "</tr>";}
$res=mysql_query('DROP TABLE TMP');
?>
</table>
</body>
</html>
[/font] E PELA PG TAH ME RETONANDO UM ERRO : erro na query Você tem um erro de sintaxe no seu SQL próximo a ';INSERT INTO TMP SELECT Codigo, RazaoSocial FROM PA0042;SELECT DATE_FORMAT(DtMov' na linha 1 O Q SERA Q PODE SER? OBRIGADO
