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
...FROM forum_posts WHERE author_id = '$Author_id'
we are assuming forum_posts has the following fields
post_id //primary key
thread_id // foreign key linked to a table holding the thread title
author_id // foreign key linked to a table w/ author/usernames
post // body of that post.
Join the friendly bunch on IRC...
Adding two coulmns
Linear Mode
