Multiple table rows, one link

[luv2climb]

Hello,

Does anyone know how I can create one displayed result from multiple rows in a table? For example, let's say in a table I have five regions: 1, 2, 3, 4 and 5. And each region has 20 or more rows of data each, identified by region number.

After the while loop goes through the table, I would want the result to simply show a single list of each of the possible regions, like this:

1
2
3
4
5

I hope this question is clear. Thank you in advance for your help.

[leatherback]

Hi,

It is possible, but it is not clear what you are looking for. Do you want to:

• Display only region numbers (so: 5 lines of output)
• All rows, but in lumps per region (So: 5 * 20 lines)
• Some statistics per region (5 lines, with a summary of something per region)

It helps if you give an example of the output you are looking for.

[luv2climb]

I'd be looking for something like

• Some statistics per region (5 lines, with a summary of something per region)

Thanks.

[leatherback]

Yeah,

Depending on whether you can do the statistics per region in the sql query (after all, you are STILL not telling what you want to output) you either can do it in the sql, or you have to place the output of your query in a 2D array, first level you region, second level the individual records for that region, and do your satts on the array.

[luv2climb]

Ok. Then just to keep it simple, suppose I had a table like this:

region info
-------- ----
1 foo
3 foo
2 foo
1 foo
2 foo
2 foo
3 foo

...and wanted the output to simply list each of the region numbers, like this:

1
2
3

In other words, show each of the individual regions being used in that table.

I suppose the php code might try to be something like "for all like values, create one result." Or, "after each loop goes through all like values, create one output result." Elementary, I know, that's the best way I know how to explain it.

[leatherback]

select distinct region from table