Quick Question

[Stotty]

On my custom forums im making the Post Count at the Moment

 

In Post.php

 

ive added

 

	mysql_query("UPDATE km_users SET posts = '+1'
WHERE playername = '$player'");

 

But when i post the post count goes to one then stops wont go up anymore

 

Why is this ??

[cpharry]

You need to add an if function which will get the highest value in the users column for posts and then you run the query that adds one to it.

 

Just putting +1 will set it to literally plus 1.

[DeanWhitehouse]

You need to do something like

<?php
$sql = mysql_query("SELECT posts FROM km_users WHERE playername = '$player'");
$sql = mysql_fetch_assoc($sql);
$posts = $sql['posts'];
$sql = mysql_query("UPDATE km_users SET posts = '".($posts + 1)."' WHERE playername = '$player'");
?>

 

 

[Stotty]

Thank you very much

[premiso]

Remember to marked as solved. (Bottom left hand corner.)

 

A quicker way to do this:

 

<?php
$sql = mysql_query("UPDATE km_users SET posts = (`posts` + 1) WHERE playername = '$player'");
?>

 

One statement is a heck of a lot quicker and slicker =)

[DeanWhitehouse]

One statement is a heck of a lot quicker and slicker =)

Speed difference is hardly noticeable if at all.

[premiso]

One statement is a heck of a lot quicker and slicker =)

Speed difference is hardly noticeable if at all.

 

Yea, but there is a difference in speed, however small it is. The main feature is, look how much simpler that is to write than having to go run a query, pull that column assign it to a value then re-use that value in another query to increment it =)

 

Much more efficient and quicker to at least write it.