MySQL help, (Simple question)

[ChrisMartino]

Ok, So i have created a users system, I know how to create a new user like this:

{
     						$registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress, AccountType, ip) VALUES('".$username."', '".$password."', '".$email."', '".$AccountType."','".$ip."')");
        				
					if($registerquery)
       						{
        						echo "<h1>Success</h1>";
        						echo "<p>You have successfully created a \'Band\' Account!. Please <a href=\"index.php\">click here to login</a>.</p>";
        					}
        					else
       						{
     							echo "<h1>Error</h1>";
        						echo "<p>Sorry, It seems there was a issue with the Database, Try again, Or contact us.</p>";    
        					}    	
     					}

 

 

But i don't know how to edit them afterwards, For example i want to edit the field "ip", How would i do that afterwards, They are logged in at this time and username session variable is $username

[oni-kun]

You should read upon basic SQL techniques before you try to code something you cannot handle.

http://www.w3schools.com/SQl/sql_update.asp

http://www.techonthenet.com/sql/tables/alter_table.php

 

$sql = "UPDATE tablename SET ip='$ip' WHERE id=$id";

or something similar for example..