function get_table_string($field_name, $search_para_str, $que_no, $analytic_array) { global $analytic_array; $sql_query_q = 'select ' . $field_name . ', count(*) from feedback_master where (' . $search_para_str . ') group by ' . $field_name . ' order by ' . $field_name; $res = mysql_query($sql_query_q) or die(mysql_error('sql error')); $data_array = array(); while ($myrow = mysql_fetch_array($res)) { // $myrow["ans5"] = rating // $myrow[1] = student count $data_array[$myrow[$field_name]] = $myrow[1]; } $que_table_string_new .= '<tr><td align="center">' . que_one_word($que_no) . '</td>'; for ($i = 0; $i < 10; $i++) { $val = $data_array[$i] ? $data_array[$i] : 0; $que_table_string_new .= '<td align="center">' . $val . '</td>'; $analytic_array[$i] += $val; } $que_table_string_new .= '</tr>'; return $que_table_string_new; }
?> '], [5, '<?php echo que_one_word(5); ?> '], [6, '<?php echo que_one_word(6); ?> '], [7, '<?php echo que_one_word(7); ?> '], [8, '<?php echo que_one_word(8); ?> '], [9, '<?php echo que_one_word(9); ?> ']] }, bars: { show: true, align:"center" }, grid: { hoverable: true, clickable: true, xaxis: false }, } $.plot($("#placeholder"), [{data: myData}], Options); }); </script> <table> <tr> <td>Batch : <?php echo $batch_name;