Jump to content


Photo

updating a sql row


  • This topic is locked This topic is locked
No replies to this topic

#1 aebstract

aebstract
  • Members
  • PipPipPip
  • Advanced Member
  • 1,105 posts

Posted 20 October 2006 - 11:10 PM

<?php
if(isset($HTTP_POST_VARS['usern'])) {
	$usern = strip_tags($HTTP_POST_VARS['usern']);
	$passw = strip_tags($HTTP_POST_VARS['passw']);
	setcookie("Username",$usern);
	setcookie("Password",$passw);
$lastloginip = $_SERVER['REMOTE_ADDR'];
require('dblogon.php');
$query = "UPDATE userinf SET lastloginip=$lastloginup WHERE username=$usern";
$r = mysql_query ($query);

	header("Location: member.php");
	exit();
}


Could someone tell me why it isn't updating lastloginip that matches my username when I log in to this website?
Thanks

There is an area of the mind that could be called unsane, beyond sanity, and yet
not insane. Think of a circle with a fine split in it. At one end there's
insanity. You go around the circle to sanity, and on the other end of the
circle, close to insanity, but not insanity, is unsanity.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users