<?php //assign visitor number by his IP address $visitor = $_SERVER['REMOTE_ADDR']; $state = 'string'; //populate by a $_GET or $_POST //build an UPDATE query $query = "UPDATE `userslocation` SET `state`='$state' WHERE `visitornumber`='$visitor' "; //execute query mysql_query($query); ?>
