creating a table from values in database

[rakennedy75]

ok, here goes...
I have a database that has rates, categories, and seasons. All three which work together. I need to display a table/chart of these. This seemed pretty simple at first but for some reason, it seems to be more difficult than I anticipated.

I attached an example of what i am talking about.

The top columns should be the seasons.
The Left rows should be the categories
The rate should populate under the corresponding field

I have three tables for this, rates, seasons & categories
Any advise on how I can create a table like the one in the example. I have an id in the rates table that correspond to other two releted tables.

I hope this made since, if not please let me know.
Thanks for your time .

[zapa]

do you know how to make basic table in HTML?
ahhh and you wanting thing in PHP?

example of table
<TABLE>
<TR>
<TD>Col one</TD>
<TD>Col 2</TD>
<TD>Col 3</TD>
<TD>Col 4</TD>
</TR>

<TR>
<TD>Col one ROW TWO</TD>
<TD>Col 2</TD>
<TD>Col 3</TD>
<TD>Col 4</TD>
</TR>

</TABLE>

each <TR></TR> you add is a row. look www.w3c.org for table format in html

as for returning you output in a table

you could use foreach or while loops

eample

echo "<TABLE><TR>";
$news=mysql_query("select * from news ORDER BY date DESC LIMIT 3") or die ("cant open/get  database");
while($rows=mysql_fetch_array($news)){ 
$date=$rows["date"];
$author=$rows["author"];
$content=$rows["content"];
echo <TD>$date</TD><TD>$author</TD><TD>$content</TD>
}

print "</TR><TABLE>";

use as needed

[rakennedy75]

Not sure if that was a sarcastic response or not, either way... thanks for taking the time to respond.

I know html very well and your typical table won't work, at least the way I am seeing it. This will load dynamically from the database variables that i have.

What I am trying to achieve is similiar to a graph you would use for a bar graph (of course without the bar).
One description(seasons) will be on the top which will represent columns and one description(categories) on the left which will represent rows.

The rates will be populated in the graph where it corresponds to both the row & col. These should be pulled by ids I stored in the rates table. So if id1 matches the season id and the id2 matches the categories id than that particular rate will be placed in the row of the category and the column of the seasons.

these are put into three tables.
1. seasons table
sid
season

2. categories table
   cid
   category

3. rates table
   sid
   cid
   rates

There is more info in each table but for brevity I kept the tables simple here. Now from this info I would like to put this into a table that i have described before. I realize that I will be using a similar table setup as the one your pointed out but where I get confused is how to do this with multiple tables. Any help would be appreciated. Thanks.

[dnast]

Hmm...seems more like a query problem. I'd put this in the database forum for better results.

I honestly can't think of a fairly simple way to do this at the moment, but I know there is.

[rakennedy75]

ok, thanks for the suggestion, I will put that in the db forum