disable after UPDATE

[Jaynesh]

Hello

 

This is the layout of my table

 

post_id    up

1            5

 

I have set up a link. Whenever somebody clicks the link it executes this query. Basically it increments the up column by 1.

How do I limit somebody from clicking it just once?

 

UPDATE Posts SET up = up +1 WHERE $up = post_id

[freelance84]

 

You would have to store somewhere that the user hand done so. If they are a member, then in a table. If not then in a cookie.

[Andy11548]

This probably isn't the best way, but it should work.

 

In the `users` table in your database, add a new field saying something like "clicked", then make it so that if they clicked the link it would update the users table such as:

 

$clicked = mysql_query("UPDATE `users` SET `clicked`='Y' WHERE `username`='$_SESSION[username]'");

 

then you could perform a check to check if its been clicked using something like

 

$clickCheck = mysql_query("SELECT `clicked` FROM `users` WHERE `username`='$_SESSION[username]'");
$clickF = mysql_fetch_assoc($clickCheck);

if($clickF['clicked']=='Y')
{
     echo 'You have already clicked the link';
     header('REFRESH: 5; index.php');
}

 

Sorry if the code is bad, I'm still a newbie at this, but just adapt that code to how you want it, and it should work.

[freelance84]

Or you could set up a new table:

 

ID  clickedID

 

 

When the user clicks the link which increments the field in the OP, it first checks to see if the users ID is in the above table, if it is send back a message saying, 'sorry you voted already, if no record is in the above table, then increment the link then add the users ID and the clickedID into the above table.

 

That way you can add as many clicked records as you like.

[Jaynesh]

Hello

 

freelance84, I've created a new table.

(user_id, post_id, clicked)

 

I know have a query whenever somebody clicks the link it adds a "1" to the clicked column.

Now how do I disable the link if it is set to "1"?

[freelance84]

 

 

I think i misunderstood your OP...

 

Is this some kind of voting system, and you only want the users to vote on any one thing once?

[Andy11548]

Jaynesh

 

Why don't you make the link visiable if they haven't clicked it, but once they have, the link is gone?