[SOLVED] Help for count code

[gli]

Hi! I cant make a code which works. Can you help me please

I need code what

counts message rows from database table messages where receiver equal to $user

and then stores this counted data to users table in pm_count row.

 

thanks.

 

sorry but i tried so much

 

[DarkWater]

<?php
$query = "SELECT * FROM whatever WHERE user=$user";
$result = mysql_query($query);
$count = mysql_num_rows($result);

$query = "INSERT INTO users (pm_count) VALUES ($count)";
$result = mysql_query($result);
?>

 

Something like that.

[gli]

thnx