Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

sql table and data ordering
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: sql table and data ordering
#3626
sql table and data ordering 14 Years, 8 Months ago Karma: 0
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
Last Edit: 2010/04/03 10:54 By sandroon.
The administrator has disabled public write access.
 
#3632
Re:sql table and data ordering 14 Years, 8 Months ago Karma: 760
Hello,

Could you explain your requirement, you need SQL query?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#3634
Re:sql table and data ordering 14 Years, 8 Months ago Karma: 0
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
Last Edit: 2010/04/04 13:13 By sandroon.
The administrator has disabled public write access.
 
#3635
Re:sql table and data ordering 14 Years, 8 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#3636
Re:sql table and data ordering 14 Years, 8 Months ago Karma: 760
You can place two instance of "ARI JTabler Sorter" plugin with necessary SQL queries.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#3644
Re:sql table and data ordering 14 Years, 8 Months ago Karma: 0
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
The administrator has disabled public write access.
 
Go to topPage: 1