help with html tables and mysql resulting rows

lmartinez

Hi.
I have some rows from a mysql query, ordered by date.
Each row has the date, the operator and a number of things made in that day for that operator.
I want to show all data from one date in columns, each column for an operator, and add a new row with the next day.
But not all days has the same operators nor number of operators.
Let's see an example.
day one-op1-2
day one-op2-5
day one-op3-4
day two-op2-2
day two-op7-1
day three-op1-3
day three-op5-3
...
And I want it this way;
<table>
<tr><td>day one</td><td>op1->2</td><td>op2->5</td><td>op3</td></tr>
<tr><td>day two</td><td>op2->2</td><td>op7->1</td></tr>
</table>

Any clue?

Thanks in advance.

nemonoman

You really should study up on HTML tables.
The table code you provided will just make an ugly table.

If you want tables to have different numbers of cells per row, you'll have to adjust the colspans, etc.

Why don't you first actually lay out the HTML table content for the data as you have provided it, and we'll help you figure out how to automate the process of loading content from the database.

Include your database structure in your answer.

lmartinez

OK.
It's not the real table structure, I know.
I really mean to insert   (nonbreaking spaces) in empty tds when there are needed.
Anyway, I should study html anyway, so you are right.
Do you mean to collect results from two tables, as operators and jobs done?
My actual schema is not this way. I have an operators table and a jobs table, but not a relational table between them.
I want to avoid further queries, if it is possible.

I just get the results as posted, walking through the array as usual (while ($row = mysql_fetch_array($query)){})

Thanks anyway.