I have a page where a code is passed in the url and then this should update my table with the info from the url.
I've been using this before, but then I had an INSERT instead of the UPDATE, which is what I need now.
But there is something wrong in my code (like always) and I just can't see it...
It's supposed to put the $number in the table and set STATUS to 1 and the registration date. It will find the id in the CODE from the url as well.
So what I will get from the URL is:
$number = $_REQUEST["number"];
$code = @urldecode($_REQUEST["code"]);
mysql_query("UPDATE table_user SET number='$number', status=1, reg_date=now(), WHERE code='$code'");
echo "It's working.";