
	
	Renders table by data from SQL query. Allows to write SQL query in plugin parameters and create table with customizable columns containing data from database.<br /><br />

	Features:
	<ul>
		<li>Needs SQL knowledge to create query;<br />
		<li>Supports SQL queries of any complexity;<br />
		<li>Customizable columns;<br />
		<li>Could be wrapped by other table plugins, for example Flex Grid or Table Sorter to adjust table look and functionality.<br />
	</ul>
	<br />

	Usage:
	<pre>
{arisqltable}
    {arisqltablecolumns}
      {arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
      {arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
    {/arisqltablecolumns}
    {arisqltablequery}
SELECT id AS ID,name AS NAME 
FROM #__users
    {/arisqltablequery}
{/arisqltable}

or 

{arisqltable}
    {ariconnectionstring dbHost="localhost" dbName="joomla" dbUser="user" 
	dbPass="pass" dbType="mysqli" persistent="false"}
    {arisqltablecolumns}
      {arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
      {arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
      {arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true"}
      	{coltemplate}{$NAME} - {$ID}{/coltemplate}
      {/arisqltablecolumn}
    {/arisqltablecolumns}
    {arisqltablequery}
SELECT id AS ID,name AS NAME 
FROM jos_users
    {/arisqltablequery}
{/arisqltable}
	</pre>
	This will create table containing user information.<br />
	arisqltablequery should contain SQL query. Arisqltablecolumns is not mandatory tag and is used for columns customization. Arisqltablecolumns tag contains arisqltablecolumn tags.
	<br /><br />

	arisqltable parameters:<br /><br />
	<b>header</b> - Display header or not. Values: true, false;<br />
	<b>footer</b> - Display footer or not. Values: true, false;<br />
	<b>cellPadding</b> - Cell padding. Values: number;<br />
	<b>cellSpacing</b> - Cell spacing. Values: number;<br />
	<b>width</b> - Table width. Values: px or percentage;<br />
	<b>className</b> - CSS class name to be applied to the table;<br />
	<b>advancedStyling</b> - If this parameter is enabled, HTML table will contain additional CSS classes for each column and row. Values: true, false;<br/>
	<b>inputEncoding</b> - Indicate input encoding. Values: input encoding.<br />
	<br /><br />
	
	arisqltablequery parameters:<br /><br />
	<b>saveTags</b> - Save HTML tags;<br />
	<br /><br />

	arisqltablecolumn parameters:<br /><br />
	<b>id</b> - Column name in SQL table;<br />
	<b>className</b> - CSS class name to be applied to content cells (td);<br />
	<b>headerClassName</b> - CSS class name to be applied to header (th);<br />
	<b>width</b> - Width. Values: px, percentage;<br />
	<b>alias</b> - Columns name to be displayed on UI. Values: string;<br />
	<b>headCellTag</b> - HTML tag. Values: th,td;<br />
	<b>cellTag</b> - HTML tag. Values: th,td;<br />
	<b>virtual</b> - Indicate that this column is virtual. Values: true, false;<br/>
	<b>hidden</b> - Indicate that this column will be hidden. Values: true, false;<br/>
	<b>pos</b> - Column order. Values: integer.<br/>
	<br /><br />
	
	arisqltablecolumnspan parameters:<br /><br />
	<b>row</b> - Row index(es). Values: zero-based row index (for header and footer use -1);<br />
	<b>startIndex</b> - Start column index. Values: zero-based column index;<br />
	<b>endIndex</b> - End column index. Values: zero-based column index;<br />
	
	ariconnectionstring parameters:<br /><br />
	<b>dbHost</b> - database host (default localhost);<br />
	<b>dbName</b> - database name;<br />
	<b>dbUser</b> - database user (default root);<br />
	<b>dbPass</b> - database pass;<br />
	<b>dbType</b> - database provider. The following values are allowed: fbsql,  gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. (Attention: plugin will work correctly only if php extensions for selected provider are installed);<br />
	<b>charsetName</b> - charset. Values: string;<br />
	<b>persistent</b> - persistent connection. Values: true, false.<br />
	
	