can some one remind me pls...

[hooch_au78]

howdy all,

i have a simple table

id company page hits

now what i wanna do is extract data from there showing results by company so i'd get something like this in my out put to a web page

company page views
company1 27
company 2 27
etc....

but what I'm getting is

company pageviews
company1 blah
company1 blah
company1 blah
company2 blah
company2 blah
etc...

Hope this makes sences.

cheers
Peter

[LordShryku]

Lets see your SQL query

[hooch_au78]

$query_stats = "SELECT * FROM hits";
$stats = mysql_query($query_stats, $test) or die(mysql_error());
$row_stats = mysql_fetch_assoc($stats);

<?php do { ?>
<tr class="ListFooterColor">
<td width="20%"><?php echo $row_stats['company']; ?> </td>
</tr>
<?php } while ($row_stasts = mysql_fetch_assoc($stasts)); ?>

[LordShryku]

OK, you definatly need a more complex query than that

$SQL = "SELECT company, sum(pagehits)
        FROM hits
        GROUP BY company";

That will sum up all of the hits and group by company

[hooch_au78]

ok i've simplified things alot to

-----------------php----------------------
<?php
require_once('Connections/test.php');
$SQL = "SELECT company, sum(counter) FROM hits GROUP BY company";
$result=mysql_query("$SQL");
do {
echo $result;
echo "<br>";
} while ($row_stasts = mysql_fetch_assoc($result));

?>

all i get as an out put is Resource id #2

any ideas?

[LordShryku]

Lets change up the whole thing here. Try this.

<? 
require_once('Connections/test.php'); 
$sql = "SELECT company, sum(counter) AS hits
        FROM hits 
        GROUP BY company"; 
$result=mysql_query($sql); 
while($row=mysql_fetch_array($result)) {
    echo $row['company']." ".$row['hits']."<br>";
}
?>

When you tried echoing $result, it is nothing more than a function (mysql_query), so it is telling you the resource id it used while performing that function. You need to fetch the results before you can echo them.

[hooch_au78]

thanks LordShryku for all your help with this. it now works the way i need it too 😃 😃 😃 😃