Results display help needed

[ned911]

Been struggling with this one for a while.

Heres what I'm trying to do: Display results of mysql query is this manner

Page Nov02 Oct02 Sep02 ...
Index.html Count Count Count
Cars.html Count Count Count

All I'm getting currently is a list with 3 columns

Date page count

Any help would be greatly appreciated.

Ned

[leatherback]

Hi,

It would help if you gave us some of the coding you have so we can have a look at where the problem might be

...

J.

[ned911]

No problem.
Here is a sample of what the code is returning.
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687
September 2002
/index.html
687

$query = "select count(page) as cnt,
page,
date_format(created, '%M %Y') as dt
from track_detail
group by dt, page
order by dt desc, cnt desc, page
";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
$page = $row["page"];
$cnt = $row["cnt"];

echo '<tr valign="top">';
for($i=1; $i<=17;$i++) {
/ there are 17 total pages to the site /
echo "<td><center>".$row["dt"]."<center></td>";
echo "<td><center>".$page."<center></td>";
echo "<td><center>".$cnt."</center></td>";
}
}

[leatherback]

Hi,

Not completely sure here.

What I think might be a problem: Grouping by dt, which is a non-existing columname, but a variable which you create (??) Perhaps you can group by the actual values: date_format(created, '%M %Y')

And I think, in order to get them in a horizontal order, you'd have to work with a nested statement; One to get the intividual creation months, and then per month retrieve the results.

Hope this helps?

J.