ORDENAR CONSULTA

[Aldan Nunes]

Galera é o seguinte tenho esta consulta juntamente com a exibição em html. O problema é o seguinte não estou conseguindo exibir em ordem esta consulta e ela está duplicando alguns dados segue a consulta.

<?php

$consultNF = mysql_query("SELECT

i.notafiscal,

i.codMaterial,

i.quantidade as QTITEMNF,

notf.id as notanumero,

notf.numeroNF,

notf.fornecedor,

notf.tipMovimento AS TPMOVNF,

DATE_FORMAT(notf.dataRecebimento , '%d/%m/%Y') AS dtrecebimento,

notf.ordemcompra as ordCompra,

forn.id as idforn,

forn.Nome as nomforn,

DATE_FORMAT(movmat.data , '%d/%m/%Y') as dtMovMat,

movmat.origem as OrigMovMat,

movmat.destino as DestMovMat,

movmat.quantidade as QuantMovMat,

movmat.tipMovimento AS TPMOVMAT,

msdra.RA as RAMovSaida,

DATE_FORMAT(msdra.data , '%d/%m/%Y') as dtMovSaida,

msdra.localizacao as locMovSaida,

msdra.quantidade as QuantMovSaida,

msdra.tipMovimento AS TPMOVRA

FROM

itemnotafiscal i,

notafiscal notf,

fornecedor forn,

movimentacaomaterial movmat,

movimentosaidara msdra

WHERE

i.codMaterial = '".$id."' AND

i.notafiscal=notf.id AND

notf.fornecedor = forn.id AND

msdra.codmaterial = i.codmaterial AND

movmat.codmaterial = i.codmaterial

ORDER BY

notf.datarecebimento, movmat.data, msdra.data")or die (mysql_error());

while($ItemNF = mysql_fetch_array($consultNF)){

?>

<tr>

<td height="20" align="left"><?php echo $ItemNF['TPMOVNF']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['dtrecebimento]; ?></td>

<td height="20" align="left"></td>

<td height="20" align="left"></td>

<td height="20" align="center"><?php echo $ItemNF['QTITEMNF']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['notanumero]; ?> - &nbsp;<?php echo $ItemNF['idforn']; ?>&nbsp;(<?php echo $ItemNF['nomforn'];?>)</td>

<td height=20" align="center"><?php echo $ItemNF['ordCompra]; ?> </td>

</tr>

<tr>

<td height="20" align="left"><?php echo $ItemNF['TPMOVMAT']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['dtMovMat]; ?></td>

<td height="20" align="left"><?php echo $ItemNF['OrigMovMat']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['DestMovMat]; ?></td>

<td height="20" align="center"><?php echo $ItemNF['QuantMovMat']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['notanumero]; ?></td>

<td height="20" align="center"> </td>

</tr>

<tr>

<td height="20" align="left"><?php echo $ItemNF['TPMOVRA']; ?></td>

<td height=20" align="left"><?php echo $ItemNF['dtMovSaida]; ?></td>

<td height="20" align="left"><?php echo $ItemNF['OrigMovMat']; ?></td>

<td height=20" align="left"></td>

<td height="20" align="center"><?php echo $ItemNF['QuantMovSaida]; ?></td>

<td height="20" align="left"><?php echo $ItemNF['RAMovSaida'];?></td>

<td height="20" align="center"> </td>

</tr>

<?php } ?>