I wish I could create some tables as values in the database. For example: if a record contains the value "x", will be in table "A" as if it contains the value "y" will be in table "B".
even better:
name, sex. I would like to separate males from females ....... I hope I explained.
many many thanks

Hello,

Could you explain your requirement, you need SQL query?

Regards,
ARI Soft

here's my tabs actually:
****************************
{arijdatatable bPaginate="true"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="Progr" alias="id" width="5%" className="idg"}
{arisqltablecolumn id="NOME" alias="nome" headerClassName="head"}
{arisqltablecolumn id="PROV" alias="provincia" headerClassName="head"}
{arisqltablecolumn id="CAT" alias="categ" headerClassName="head"}
{arisqltablecolumn id="CLASSE" alias="classe" headerClassName="head"}
{arisqltablecolumn id="MODELLO" alias="modello" headerClassName="head"}
{arisqltablecolumn id="MOTORE" alias="motore" headerClassName="head"}
{arisqltablecolumn id="GOMME" alias="gomme" headerClassName="head"}
{/arisqltablecolumn}
{arisqltablequery}
SELECT id AS Progr,nome AS NOME,cognome AS COGNOME,provincia AS PROV,categ AS CAT,classe AS CLASSE,modello AS MODELLO,motore AS MOTORE,gomme AS GOMME FROM Iscrz_italbig_2k10
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}
**************************************
I need to separe the two possibles value of the "classe" field in two different tables.
First i've think about a simple column ordering, but now i'd prefer to separate the tabs so i'll can see the class "x" in one table anche the class "y" in the other one. ...

my actual tab
snipurl.com/v926q

now it almost works
******************************
{arijtablesorter defaultSorting="4:ASC,5:ASC" sorting="TRUE" notSortableCols="0,1,2,3,6,7,8"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="Progr" alias="id" width="5%" className="idg"}
{arisqltablecolumn id="NOME" alias="nome" headerClassName="head"}
{arisqltablecolumn id="PROV" alias="provincia" headerClassName="head"}
{arisqltablecolumn id="CAT" alias="categ" headerClassName="head"}
{arisqltablecolumn id="CLASSE" alias="classe" headerClassName="head"}
{arisqltablecolumn id="MODELLO" alias="modello" headerClassName="head"}
{arisqltablecolumn id="MOTORE" alias="motore" headerClassName="head"}
{arisqltablecolumn id="GOMME" alias="gomme" headerClassName="head"}
{/arisqltablecolumn}
{arisqltablequery}
SELECT id AS Progr,nome AS NOME,cognome AS COGNOME,provincia AS PROV,categ AS CAT,classe AS CLASSE,modello AS MODELLO,motore AS MOTORE,gomme AS GOMME FROM Iscrz_italbig_2k10
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}
******************************

and now i have to separate the tabs by 2 different query

You can place two instance of "ARI JTabler Sorter" plugin with necessary SQL queries.

Regards,
ARI Soft

Finally i've decided to publish some different tables showing some different query's results.
One like this:

{arijdatatable}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="Progr" alias="id" width="5%" className="idg"}
{arisqltablecolumn id="NOME" alias="nome" headerClassName="head"}
{arisqltablecolumn id="PROV" alias="provincia" headerClassName="head"}
{arisqltablecolumn id="CAT" alias="categ" headerClassName="head"}
{arisqltablecolumn id="CLASSE" alias="classe" headerClassName="head"}
{arisqltablecolumn id="MODELLO" alias="modello" headerClassName="head"}
{arisqltablecolumn id="MOTORE" alias="motore" headerClassName="head"}
{arisqltablecolumn id="GOMME" alias="gomme" headerClassName="head"}
{/arisqltablecolumn}
{arisqltablequery}
SELECT id AS Progr,nome AS NOME,cognome AS COGNOME,provincia AS PROV,categ AS CAT,classe AS CLASSE,modello AS MODELLO,motore AS MOTORE,gomme AS GOMME
FROM Iscrz_italbig_2k10 WHERE classe = 'expert' AND categ = '1/5 GT'
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}
*******************************

the second will be varied in the "WHERE" condition..



sorry, but i'm really a rookie!!1


thank you so much