counting how many post

[aznjay]

I'm trying to make a script which stores how many post they have done so they have a history of how many post they have ......hehe.....it wouldn't add the number.

	$updater = "SELECT * FROM users WHERE username='$userses'";
	$update_result = mysql_query($updater) or die (mysql_error());
	while ($rower = mysql_fetch_assoc($update_result))
	  {
	    $postcount = $rower['postcount'];
	  }
	  $postcount = $postcount+1;

mysql_query("UPDATE users SET postcount='$postcount'");

[devinemke]

what is your data structure? it looks as though your probably have (at least) two tables: users and posts. if you simply want to find out how many post a user has then:

$result = "SELECT COUNT(*) AS post_count FROM posts WHERE user_id = '$user_id'";

i don't know you structure so this is just a guess at the table/field names.

[aznjay]

i have two database that are open one is guest and the other one is users. the postcount is in the users.