How can i retrieve data using sql.....? #15
Description
i am previously done it using data table........How can i fetch this data to streamtable? Here is my example:
<?php
$con = mysql_connect("localhost","root","aaaa");
$db = mysql_select_db("anyname",$con);
$sql = "SELECT `action_id` ,`prn`, `name`, `action` , `department` , `status`, `addedtime` FROM `action_tbl` ; ";
$query = mysql_query($sql);
while($fetch = mysql_fetch_array($query))
{
$output[] = array ($fetch["action_id"],$fetch["prn"],$fetch["name"],$fetch["action"],$fetch["department"],$fetch["addedtime"],$fetch["status"]);
}
echo json_encode($output);
?>