I need to update ONE entry in a mysql table. This is what I have, but is not working
UPDATE $mysql_table_credits SET Status='1' WHERE Username='$value' AND Status='0' LIMIT 1
Now there will be many entries with the same username, and I need to update ONE of them to change the status from 0 to 1.
UPDATE $mysql_table_credits SET Status='1' WHERE Username='$value' AND Status='0' LIMIT 1
Now there will be many entries with the same username, and I need to update ONE of them to change the status from 0 to 1.