Posted by Roy Schestowitz on 08/22/05 18:07

On Monday 22 August 2005 04:20, Ross wrote:

> dear all, i have the following table of data to post on web,
>
> name size length 0min 3min 10min chart
> A 3 5 1 10 3 figA.gif
> B 5 2 2 4 3 figB.gif
> C 4 3 3 9 6 figC.gif
> ...
>
> I am seeking your advice on the programming language for such an action. i
> prefer a web table capable of sorting by size, length and so on, therefore
> built-in function for sorting is appreciated.

Hi Ross,

I always prefer to think in terms of comma-separated values when handling
spreadsheets. Let us say that you use PHP and then pick one token at a time
with the intention of feeding it in to the database.

Thereafter, all you ought to do is create a database with tuples that
correspond to the columns of the table above. You should create some
meaningful functions (abstraction) to fetch column (value) given field
(row) and then work deeper to get more complex operations working. There
must be something like this lying around publicly, so don't re-invent the
wheel if possible. Do your homework before implementing anything.

To output the data, it would sensible in this particular case to place
everything in tables (Look ma! No divs!), e.g.

<table>
<tbody>
<tr>
<td>
A
</td>
<td>
3
</td>
<td>
6
</td>
<td>
1
</td>
<td>
10
</td>
<td>
3
</td>
<td>
<img src="figA.gif" alt="figA" />
</td>
</tr>
</tbody>
</table>


Hope it helps,

Roy

--
Roy S. Schestowitz Useless fact: Florida is bigger than England
http://Schestowitz.com

[Back to original message]