display data

vang

hi,

i want to retrieve data and display this way in the mouseover TAB, how can i do it?

MYSQL Table

col1 col2 col3 col4 col5 col6....

Display Table on TAB1

TAB1 TAB2 TAB3
col1 | col2 | col3

Display Table on TAB2

TAB1 TAB2 TAB3
col4 | col5 | col6

Display Table on TAB3

TAB1 TAB2 TAB3
col7 | col8

Currently, I'm using select * from table limit x, y and can only display all column data in TAB1. I want to split some column to TAB 2 and TAB 3...
Any advice is appreciated, thanks.

dagon

new tables or just new rows after every third?
I think this may be what your after: Displaying Three or Four Items per Row in a Table

vang

There can be many columns in a mysql table.
I can choose to have many tabs as i seem fit.
I can choose to display 3 columns in the first tab, 5 columns in the TAB 2, 4 columns in TAB 3, 6 columns in TAB 4, .......

dagon

same principle as in the tutorial, you just have to factor in that's its not a set number of rows per table.