Ludatha
03-09-2008, 04:09 PM
Hi, I have problem, when a user comments on another user's profile it posts 2 comments and adds 2 to the comment count.
function sign()
{
// Sign the guestbook
require_once("classes/DbConnector.php");
$username = $_GET["sign"];
$from = $_GET["from"];
$message = $_POST["message"];
$time = date("F j, Y, g:i a");
$db = new DbConnector();
$db->connect();
$query = "INSERT INTO guestbook(owner,postedby,post,time) VALUES('$username','$from','$message','$time')";
$db->query($query);
echo "<p>Your message has been posted</p>";
// Hit Counter Script
$member = $_SESSION["username"];
require_once("classes/DbConnector.php");
$db = new DbConnector();
$db->connect();
$query = "UPDATE members SET commentCount = commentCount +1 WHERE username='$member'";
$result = $db->query($query);
}
Anyone know what to do to make it post the comment once and add 1 to the counter?
This also happens to my hit counter for the user's page views.
// Hit Counter Script
$member = $_GET["id"];
require_once("classes/DbConnector.php");
$db = new DbConnector();
$db->connect();
$query = "UPDATE members SET hits = hits +1 WHERE username='$member'";
$result = $db->query($query);
function sign()
{
// Sign the guestbook
require_once("classes/DbConnector.php");
$username = $_GET["sign"];
$from = $_GET["from"];
$message = $_POST["message"];
$time = date("F j, Y, g:i a");
$db = new DbConnector();
$db->connect();
$query = "INSERT INTO guestbook(owner,postedby,post,time) VALUES('$username','$from','$message','$time')";
$db->query($query);
echo "<p>Your message has been posted</p>";
// Hit Counter Script
$member = $_SESSION["username"];
require_once("classes/DbConnector.php");
$db = new DbConnector();
$db->connect();
$query = "UPDATE members SET commentCount = commentCount +1 WHERE username='$member'";
$result = $db->query($query);
}
Anyone know what to do to make it post the comment once and add 1 to the counter?
This also happens to my hit counter for the user's page views.
// Hit Counter Script
$member = $_GET["id"];
require_once("classes/DbConnector.php");
$db = new DbConnector();
$db->connect();
$query = "UPDATE members SET hits = hits +1 WHERE username='$member'";
$result = $db->query($query);