Jump to content

Archived

This topic is now archived and is closed to further replies.

Johnnnnny1986

Top PM's sent by a member

Recommended Posts

im trying to get a top pm's sent member list ive got the total pms sent working and the top list working but i cant get the MySQL database to update the number of pms sent my that member ive tried lots of ways and it just gets the total up to 1 can someone help me with the coding for this bit please.

I thought this would do it but it dosent

$sqlthing = mysql_query("SELECT * FROM pmssent WHERE '$username'");
$pmssent=(mysql_result($sqlthing,0,"pmssent"));
$pmssent=$pmssent+1;

$query = "update members set pmssent='$pmssent' where username='$username'";
mysql_query($query);

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.