Support

March 18, 2014 at 8:12 pm

I’m trying to create shortcodes for wordpress.
I would like to display by DISTINCT from ‘answer’ but COUNT the TOTAL from ‘answer’.

If you find on foreach in my code, I have no idea how to echo the count

currently i’m using count($data->answer);

Please take a look

TABLE : wp_events_answer

??????????????????????????????????
? id ? answer ?question_id ?
??????????????????????????????????
? 1 ? Maybank ? 12 ?
? 2 ? Maybank ? 12 ?
? 3 ? Maybank ? 12 ?
? 4 ? CIMB ? 12 ?
??????????????????????????????????

My desired outcome is

??????????????????????????????????
? No ? Bank ? Total ?
??????????????????????????????????
? 1 ? Maybank ? 2 ?
? 2 ? CIMB ? 1 ?
??????????????????????????????????

My current outcome

??????????????????????????????????
? No ? Bank ? Total ?
??????????????????????????????????
? 1 ? Maybank ? 1 ?
? 2 ? Maybank ? 1 ?
? 3 ? Maybank ? 1 ?
? 4 ? CIMB ? 1 ?
??????????????????????????????????

=

$sql= ”
SELECT *, count(*)
FROM wp_events_answer
INNER JOIN wp_events_attendee ON wp_events_attendee.registration_id= wp_events_answer.registration_id
WHERE question_id=12 AND event_id=’$eventid’ GROUP by answer
“;

$datas= $wpdb->get_results($sql);
$num_rows = $wpdb->num_rows;
if ($num_rows > 0)
{
$result .= ‘<table id=”attendeeList”>
<thead>
<tr>
<th width=”10%” scope=”col”>No.</th>
<th width=”70%” scope=”col”>Group Name</th>
<th width=”20%” scope=”col”>Total</th>
</tr></thead>’;
$number = 1;

foreach ($datas as $data) {
$result .= ‘<tbody>’;
$result .= ‘<tr>’;
$result .= ‘<td>’;
$result .= $number++;
$result .= ‘</td>’;
$result .= ‘<td>’;
$result .= $data->answer;
$result .= ‘</td>’;

$result .= ‘<td>’;
$result .= count($data->answer); //i have no idea how to print total this
$result .= ‘</td>’;

$result .= ‘</tr>’;
}
$result .= ‘</table>’;

return $result;

}
else
{ return ‘There is no group’; } }