Prosecution
{arijdatatable id="prosec" bLengthChange="true" asStripClasses="list_odd,list_even" iDisplayLength="20"}{arisqltable width="100%"}{ariconnectionstring dbHost="localhost" dbName="mydb_prosecution" dbUser="root" dbPass="d05HP0r7@lmysql" dbType="mysqli" persistent="false"}{arisqltablecolumns}{arisqltablecolumn id="date" alias="Date" headerClassName="head" width="10%"}{arisqltablecolumn id="companyz" alias="Company" headerClassName="head" width="15%"}{arisqltablecolumn id="cat" alias="Category" headerClassName="head" width="10%"}{arisqltablecolumn id="court" alias="Court" headerClassName="head" width="10%"}{arisqltablecolumn id="kes" alias="Case" headerClassName="head" width="45%"}{arisqltablecolumn id="fine" alias="Fine" headerClassName="head" width="15%"}{/arisqltablecolumns}{arisqltablequery} SELECT DATE_FORMAT(date_case,'%d-%m-%Y')AS date,comp_name AS companyz, vm_cat_ind AS cat,vm_court AS court,vm_case AS kes, ve_fine as fine FROM tbl_prosecution_2018 ORDER BY date_case DESC {/arisqltablequery}{/arisqltable} {/arijdatatable}
