Gah, I thought I had it all working but no, the IP address field doesn't want to update. So I need to know what I'm doing wrong again.

This page was and is working on the validation checks and such. Only the IP address update isnt working. The table contains 6 or 7 fields too, if this makes a difference.




$ud_ipadd=$_POST['ud_ipadd'];
$plogin=$_POST['plogin'];


$username="cameron_admin1";
$password="monkey666";
$database="cameron_chatdb";


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");


$query="SELECT * FROM players WHERE login='$plogin'";
$result=mysql_query($query);


$num=mysql_numrows($result);


~~Some If/Else Statements
~~For input validation
~~and Option layout

This is tied in to the end of the password check and therefore options layout elseif statement

$query = " UPDATE players SET ipadd='$ud_ipadd' WHERE login='$plogin' ";
echo "$ud_ipadd";
print mysql_error();
mysql_close();