[D_tunisia]

Hi want to do a post count for a news script I have written. All of my users have ID#'s which are referanced to posts in a table. Does anyone know how I do a count of all of the user's posts from my table?

Thanks.

[Infinite_Hackers]

i think it's something like this..

PHP Code:

   $query = "SELECT count(*) FROM TABLE_NAME WHERE ID_USER='$USER_ID'";

   $result = mysql_query($query);

   $query_data = mysql_fetch_row($result);

   $total_posts = $query_data[0];

   

   echo $USER_ID . ' posted ' . $total_posts . ' news articles'; 

see if that works (you have to mod it so it works for your script)

[NeverMind]

to make it clearer using COUNT() is the solution .. as it said it counts records ..
and the rest is like Infinite_Hackers wrote ..

[D_tunisia]

Thanks for the help, that works great!