I can’t test my code by now, but maybe it can be useful if I understand your method and the code are corect. I will test the code when I can and correct this if is needed.

$sql = "SELECT username, COUNT(*) as total FROM `feedbacks` WHERE `createdate` = '2016-03-18' GROUP BY username"; $results = mysqli_query($connect, $sql); foreach($results as $result) { echo $result[****'username'].' '.$result[****'total']; }

What do you mean with “I am not able to make it work using PHP”? What is the problem you are having or errors you are getting?

(Also, what is a “MySQLi query”?)

In the MySQLi docs, they say that you must compile PHP with support for the MySQLi extension.

more information there:
http://www.w3schools.com/php/php_ref_mysqli.asp

What about PDO for querying?
http://php.net/manual/fr/class.pdo.php

Cheers

@bolofecal : The query works perfectly. Thank you so much. I am trying to put that into a table format to display the results but unable to do it. Is there way that I can move that foreach down in the HTML. for example :

<table>  
<tr>  
<td>Username</td>  
<td>Feedback Count</td>  
</tr>  
<?php foreach($results as $result) { ?>  
<tr>  
<td>Result of username</td>  
<td>Result of Feedback Count</td>  
</tr>  
<?php } ?>  
</table>  

If I understand correctly you try put the results inside a table:

<table> <tr> <td>Username</td> <td>Feedback Count</td> </tr> <?php foreach($results in $result) { echo '<tr><td>'.$result[****'username'].'</td><td>'.$result[****'total'].'</td></tr>'; } ?> </table>

@bolofecal: *as

This should work as well:

<table>  
    <tr>  
        <td>Username</td>  
        <td>Feedback Count</td>  
    </tr>  
    <?php foreach ($results as $result) { ?>  
    <tr>  
        <td><?= $result[**'username'] ?></td>  
        <td><?= $result[**'total'] ?></td>  
    </tr>  
    <?php } ?>  
</table>  

Great, this is more clear, @dloser ever reduces the code :)

@dloser, I see that you use php short tags in your code, what’s your opinion about using them?

I always avoided using them on all my projects but as of php >=5.4 there has been some changes, but I still never use them.

I don’t really have a big opinion. Whether you use them or not, it’s still PHP. ;)

In general I’d say whatever is more readable in that case. Unless there is a very significant performance penalty.

Hmm I see, never really liked them. It’s probably a “religious” thing like spaces vs tabs… I was just curious.

DId someone say… “Spaces vs tabs” ?
Whyyy using spaces ? :(

Why? Because the size of space is constant while a tab’s depends on settings. Tabs suck.

Same here, spaces. I always remap tabs to spaces.
And it avoids me headaches on multi-line indentation, expecially when working with other devs, I’ll never switch back to tabs.

So much hate for tabs wow
I’ll use spaces now lol :)

Thank you @bolofecal , @dloser and everyone else for helping me with this. I was able to make it work. Closing this thread. Thank you once again.