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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

How can I group by ?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: How can I group by ?
#2961
How can I group by ? 7 Years, 9 Months ago Karma: 0
Hello,

I have a table which is working fine so far. The code is:

{arijtablesorter defaultSorting="4:ASC" sorting="TRUE" notSortableCols="0,1,2,3"}
{arisqltable}
{arisqltablequery}
SELECT spieler AS "Spieler"
,pins AS "Pins"
,spiele AS "Spiele"
,(pins/spiele) AS "Schnitt"
,platz AS "Platz"
FROM fab_ergebnisse
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}

Now I need two things:

1. I need to GROUP BY spieler
But when I change the code like this

{arijtablesorter defaultSorting="4:ASC" sorting="TRUE" notSortableCols="0,1,2,3"}
{arisqltable}
{arisqltablequery}
SELECT spieler AS "Spieler"
,sum(pins) AS "Pins"
,sum(spiele) AS "Spiele"
,(sum(pins)/sum(spiele)) AS "Schnitt"
,platz AS "Platz"
FROM fab_ergebnisse
GROUP BY spieler
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}

there is no output in the frontend anymore.

2. I need to get data from a second database within this query. But when I change it like this

{arijtablesorter defaultSorting="4:ASC" sorting="TRUE" notSortableCols="0,1,2,3"}
{arisqltable}
{arisqltablequery}
SELECT name AS "Spieler"
,pins AS "Pins"
,spiele AS "Spiele"
,(pins/spiele) AS "Schnitt"
,platz AS "Platz"
FROM fab_ergebnisse
INNER JOIN jos_users ON id=spieler
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}

there is no output in the frontend anymore.
I also tried it in different ways (From fab_ergebnisse as "FE"....) but it didn't work, too.

Can somebody help me?

Thank you in advance
clioschrotter
The administrator has disabled public write access.
 
#2962
Re:How can I group by ? 7 Years, 9 Months ago Karma: 667
Hello,

Could you provide temporary access to your Joomla! backend by email that we can investigate this issues because it requires knowledge of the structure of your tables?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#2963
Re:How can I group by ? 7 Years, 9 Months ago Karma: 0
Thank you for your quick response.
Mail with access data was sent to you.

Kind regards,
clioschrotter
The administrator has disabled public write access.
 
#2964
Re:How can I group by ? 7 Years, 9 Months ago Karma: 667
Try open your page now, please. We have inserted into article code which you post above and all work fine, but we insert plugin code in 'HTML' mode in WYSIWYG editor. It seems that code didn't work because your WYSIWYG editor added extra HTML tags to SQL queries and broke these.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#2965
Re:How can I group by ? 7 Years, 9 Months ago Karma: 0
Thank you very much, it works great now!!!!

Fast and great support, thanks again.

Kind regards,
clioschrotter
The administrator has disabled public write access.
 
Go to topPage: 1