what are you looking for here?!
some help on how to do it or the script itself.
if u know how to insert records using mysql, all u have to do is run it in a variable
say ur sql code was
INSERT into table (name, age, address) values ($name, age, address);
the code in php would be
$sql = "INSERT into table (name, age, address) values ($name, age, address)";
$query = mysql_query($sql);
the variables $name, $age and $address would be loaded from the form on the previous page, either with get or post
GET
$name - $GET[name];
$age - $GET[age];
$address - $_GET[address];
POST
$name - $POST[name];
$age - $POST[age];
$address - $_POST[address];
the variable name depends on the name of the text field, so if the name of the text field was post_code the variable would be $post_code / $GET[post_code] / $POST[post_code]
to display the information currently in the database for the specific user, you would need some method of identifying the user
for this example i will use get method
if the use wants to change their infomation they would click a link, say if the id of the user in the database was 213 the url could be
usercp.php?user=213
php would get that variable and use it to create a mysql function
$sql = "SELECT * from table where id='".$_GET[user]."';
$query = mysql_query($sql);
to then show the information you would use a while loop
<?
while ($row = mysql_fetch_array($query)) {
?>
<form method="post" action="<?=$PHP_SELF?>">
<input type="text" value="<?=$row[name]?>" name="name">
<input type="text" value="<?=$row[age]?>" name="age">
<input type="text" value="<?=$row[address]?>" name="address">
<input type="submit">
</form>
<?
}
?>
so the code to display users info would be
<?
$sql = "SELECT * from table where id='".$_GET[user]."';
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
?>
<form method="post" action="<?=$PHP_SELF?>">
<input type="text" value="<?=$row[name]?>" name="name">
<input type="text" value="<?=$row[age]?>" name="age">
<input type="text" value="<?=$row[address]?>" name="address">
<input type="submit">
</form>
<?
}
?>
and to insert records
<?
$sql = "INSERT into table (name, age, address) values ($name, age, address)";
$query = mysql_query($sql);
?>
hope this helps
