I'm a little confused here.
You have a 15x3x3 set of data to display in a 3 column, 15 row datagrid?
Are you displaying a single value in each cell of the datagrid, or all 3
values for the cell?
How many variables are needed to uniquely select a piece of data from
that 3-dimensional space?
Can you provide a little more detail about the data?
-Matt
On 09/19/2012 11:44 AM, Bruno Sandivilli wrote:
Anyone? Please.
2012/9/18 Bruno Sandivilli <bruno.sandivilli@xxxxxxxxx>
Hi, i strugling to decide what is the best choice:
I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have
3 values.
To represent this in my Database, I could:
1. Create 2 Tables : A Values table - with 3 columns ; and a Bill
table (with 15 foreign keys, each one pointing to one row in the Values
table).
2. Create one Table with 45 columns (15 fields * 3 values for each
field).
I want to know, wich is the best choice?
To manage my query, now i have a SELECT with a thousand of leftJoins.
This is the best choice?
How could I run a query wich will give all results linked, like:
( column_1_val_1, column_1_val_2, column_1_val_2,
column_2_val_1, column_1_val_2, column_1_val_3,
etc...) ?
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
