zetastreak

I have my data array which i converted to json by splitting the keys using for each loop. Data: $data = Array ( [table6-ios-camt] => [table6-ios-iamt] => [table6-ios-samt] => [table6-ios-type] => [table6-isd-camt] => 0 [table6-isd-iamt] => 0 [table6-isd-samt] => 0 [table6-isd-type] => [table6-ios-csamt] => [table6-isd-csamt] => 0 [table6-other-camt] => [table6-other-iamt] => [table6-other-samt] => [table6-other-type] => [table6-tran1-camt] => 0 [table6-tr

sure! will work on it, this will enable me to use ajax calls in subjectwise google charts too

yea while re-writing my line numbers got changed '-' . well relating to line numbers in your snippet the error was at line 40.

Rewriting the function did the thing, you were right! there were hidden characters lurking around only this timme while rewriting it i missed ; in $opts .= "<option>{$s['name']}</option>\n"; that's why i was getting Parse error: syntax error, unexpected '}' on line 35 finally got it working. Thank you for helping me

did that, re-wrote the whole function again still getting the error but now it's Parse error: syntax error, unexpected '}' on line 35

well tried this too , error still persists atm , it's exactly your modified code in my files. reading through error documentations if i could find something

@Barand i think it's because of the query not being able to execute correctly. i copy pasted your code and modified required parameters still issue persists. can you post your db_inc.php?

function nameOptions($connect) { $query = "SELECT DISTINCT name FROM csv ORDER BY name DESC "; $statement = $connect->query($query); $opts = ' '; foreach ($statement as $s) { $opts .= "<option>{$s['name']}</option>\n"; } return $opts; } here ,it's the same as yours

I've thoroughly checked the whole file for missing ; i found none still the error persists

That's a really optimised way of doing this. thanks for that! I owe you for this project! .-. i modified my code to the same but for some odd reason i'm getting Parse error: syntax error, unexpected '$opts' (T_VARIABLE) in charts.php on line 37 i've checked for unclosed semi-colons there are none

@Barand Well first of all many thanks to you for sharing your methods and improving my knowledge regarding these topics and other small issues. I adjusted my code accordingly with your specified edits, but i still get blank page i think i'm still having issues with parsing json data. And Thanks again for those extra efforts you made

sure i'll go through the process

@gizmola Yes i've checked everything, i'm not getting any errors

@Barand yes mate ._.' it's my first project which involves such use of queries sorry about that. thanks for pointing it out , i made the required changes in the query and the charts still won't load i always get blank page

i've to populate google charts with dynamic data. the data looks llike. +----+-------+---------+-------+-----------+---------+------+ | id | name | physics | maths | chemistry | biology | sst | +----+-------+---------+-------+-----------+---------+------+ | 1 | Name1 | 10 | 25 | 35 | 42 | 62 | | 2 | Name2 | 80 | 45 | 45 | 45 | 25 | | 3 | Name3 | 63 | 25 | 63 | 36 | 36 | | 4 | Name4 | 82 | 36 | 75 | 48 | 42 | | 5 | Name5 | 45 | 45 | 78 | 25 | 24 | | 6 | Name6 | 36