Count

[Ndogg]

I want to count how many banners a user has posted:

PHP Code:

$query = mysql_query('SELECT author, COUNT(author) FROM graphic GROUP BY author') or die(mysql_error()); 


How do I make it so it counts the rows(author) and to get the username to select its $username.

[Zangeel]

PHP Code:

 $query = mysql_query('SELECT COUNT(author) FROM graphic GROUP BY author') or die(mysql_error()); 


[Ndogg]

same thing happens

[Zangeel]

PHP Code:

$q = mysql_query("SELECT count(author) FROM `graphic` WHERE `author` = 'username goes here'");

$row = mysql_fetch_assoc($q);

echo 'Username posted' . $row['count(author)'] . ' banners'; 


[Ndogg]

Its not displaying anything now?

[Ndogg]

Nevermind, fixed it, thanks!