json - Removing title from select query in PHP -


is there way select table in sqlite without printing column headers?

the following code using:

select realpow, timestamp  powerdata;  //to loop through table , fetch data real power while($res = $results->fetcharray(sqlite3_assoc)){     $equal[] = $res; } echo json_encode($mearray,json_numeric_check); 

result:

[{"realpow":50,"timestamp":1391990400},{"realpow":200,"timestamp":1392422400}, {"realpow":100,"timestamp":1394409600},{"realpow":150,"timestamp":1395273600}, {"realpow":140,"timestamp":1397952000},{"realpow":130,"timestamp":1398384000}, {"realpow":120,"timestamp":1400544000},{"realpow":90,"timestamp":1402358400}, {"realpow":100,"timestamp":1402790400}] 

i want remove "realpow:" & "timestamp:".

here code modified:

select realpow, timestamp powerdata;      //to loop through table , fetch data real power     while($res = $results->fetcharray(sqlite3_assoc)){         $equal[] = array($res['realpow'], $res['timestamp']);     }     echo json_encode($mearray,json_numeric_check); 

Comments

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -