Penaksir Risiko Bising

{arijdatatable bLengthChange="true" asStripClasses="list_odd,list_even" iDisplayLength="20"} {arisqltable}{ariconnectionstring dbHost="localhost" dbName="mydb_list" dbUser="root" dbPass="P@ssw0rd4D0sh" dbType="mysqli" persistent="false"}{arisqltablecolumns}{arisqltablecolumn id="ref" alias="Reference No" headerClassName="head" width="12%"}{arisqltablecolumn id="Oyk_Name" alias="Name" headerClassName="head" width="20%"}{arisqltablecolumn id="Oyk_Email" alias="Email" headerClassName="head" width="10%"}{arisqltablecolumn id="Oyk_Tel" alias="Tel No." headerClassName="head" width="12%"}{arisqltablecolumn id="Date" alias="Expired Date" headerClassName="head" width="10%"}{/arisqltablecolumns}{arisqltablequery} SELECT Ref_No AS ref, Oyk_Name, Oyk_Tel, Oyk_Email, DATE_FORMAT(OYK_Expiry,'%d/%m/%Y') AS Date FROM tbl_oyl_peb WHERE (OYK_Expiry >= CURRENT_DATE()) ORDER BY Ref_No ASC {/arisqltablequery}{/arisqltable} {/arijdatatable}

Cetak Emel