TalkPHP - View Single Post

tearsofthesun · 08-19-2009, 10:39 AM

I'm trying to get the total post of a user in my forum but my code doesn't work.

PHP Code:


			
<?php

$query = mysql_query('SELECT author, post, COUNT(*) FROM forum_posts') or die (mysql_error());

$result = mysql_result($query) or die (mysql_error());;

echo '$result';

?>

EX: adding author and post = 25 or something like that

08-19-2009, 10:39 AM	#1 (permalink)
tearsofthesun The Wanderer Join Date: Aug 2009 Posts: 15 Thanks: 11	Adding two coulmns I'm trying to get the total post of a user in my forum but my code doesn't work. PHP Code: `<?php $query = mysql_query('SELECT author, post, COUNT(*) FROM forum_posts') or die (mysql_error()); $result = mysql_result($query) or die (mysql_error());; echo '$result'; ?>` EX: adding author and post = 25 or something like that