elcodigo q uso para mostrar el resultado es este
Código PHP:
$sql="SELECT right(fecha,4)as any,tendes,fecha,Count(numero) AS clients,Sum(total) AS total
FROM tickets INNER JOIN tendes ON id_tenda = tienda
GROUP BY tendes,fecha
HAVING fecha='".$data_usuari."'OR fecha='".$data_passada."'
".$criterio."
ORDER BY ".$orden." ASC LIMIT ".$limitInf.",".$tamPag;
$res=mysql_query($sql);
while($registro=mysql_fetch_array($res))
{
?>
<!-- taula de resultats -->
<tr bgcolor="#CCCCCC" onMouseOver="this.style.backgroundColor='#EFEFEF';this.style.cursor='hand';" nMouseOut="this.style.backgroundColor='#CCCCCC'"o"];",'Ticket','width=600, height=350')">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b><? echo $registro["any"]; ?></b></font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b><? echo $registro["tendes"]; ?></b></font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b><? echo $registro["clients"]; ?></b></font></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b><? echo $registro["total"]; ?></b></font></td>
</tr>
<!-- fi taula resultats -->
<?