How do I show the results of count?

Anon

I'm trying to make it so it will display the amount of posts the author has made. I have this:

$countposts=mysql($config->DBname,"select author, count() from forumthreads where author=$author group by author");
$posts=mysql_result($countposts,1,"count()");

and then a bit down, I have this:

echo "fontfacemain,"'> $author messagecolor,"'> (",$posts," posts)</td></tr>";

I know my error is in the $post variable. I've messed around with it and tried different things, but I can't get it to work. I'm not sure what I'm supposed to put for the $posts variable so I get a number that'll display.

Anon

err... html killed my post

here's what the echo should've been:

echo "fontfacemain,"'> $author messagecolor,"'> (",$posts," posts)</td></tr>";

Anon

Change your query to read:

select author, count(*) as count from fourmthreade where author=$author group by author

Then you can access the count(*) using the column name count. Anytime you use an sql function this is what you should do so that you can get the value back out in PHP.

Anon

I needed to put single quotes around the variables....