Updating a mysql row's contents, not adding a new row

Hey everyone,

I was hoping someone could help me. This is what I want to do:

I want to make it so that when someone enters text into a form, the text is entered into a mysql database. However, the way I want it to work is, when the person enters text into that field at a later date, it updates it instead of adding another row in the db.

Can someone please tell me the easiest way to do this? Thanks.

Sorry about the bad wording.

<form method="post" action=" <?php echo $PHP_SELF ?>">
<br>
Your text<br>
<input type="Text" name="your var" size="30">
Enter your ID<br>
<input type="Text" name="id" size="30"> </form>

<?php
$hostname = "localhost";
$username = "your username";
$password = "your password";
$dbName = "your database";
$userstable = "your table";

if ($submit) {
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database");

@mysql_select_db("$dbName") or die("Unable to select database");
$result = mysql_query ("SELECT * FROM $userstable WHERE id = '$id'");

$query = "REPLACE INTO $userstable SET your table colum name = '$your var'";
$result = MYSQL_QUERY($query);
}

?>

Put this in your html this will work to update an exsisting record you will have to adapt this to your needs. I hope this helps you


------------------
good luck Dr.E.L.

[This message has been edited by Dr_E_lectric (edited June 02, 2000).]

[This message has been edited by Dr_E_lectric (edited June 02, 2000).]

I don't see the reason for that first mysql_db_query statement with the SELECT.

Instead of REPLACE, you can also use UPDATE:

mysql_db_query("UPDATE $table SET text='$input_text' WHERE id='$id'");

---John Holmes
---www.SepodatiCreations.com