Changing Data in MySQL Field

[Anon]

I am trying to make the first page in my website application have a simple to change introduction by a web form.

I can get the data to insert in to the table BUT... i dont want to insert I want to change it..?? HELP

here is the php code to help you understand that I need help with.

<?php
include("../include/dbconnect.inc");

if ($submit == "Submit")

{
$query = "insert into main
(content) values
('$content')"
;
mysql_query($query) or
die (mysql_error());

?>
<h2>Welcome Message has been changed</h2>
<?php
}
else
{
include("main.php");
}
?>

I need that code to change data instead of insert it... Please help me

[[deleted]]

http://www.mysql.com/doc/U/P/UPDATE.html

[Anon]

Not what I was after... I have a variable length text string which I wish to have changable... at the minute it adds to it... instead of changing?? why what command do i need to use... i am a newbie to this mysql php thing... so as much help as possiable is aprichated

Thanks

[[deleted]]

"I have a variable length text string which I wish to have changable... at the minute it adds to it... "

so you want to change the content of a database record. Update does that, read it again.

[Anon]

ok thanks all.. gettin there.. One last thing...

If there is allready data in that feild then I do not want it to insert more in to the setup script... incase the lamer runs it more than once ... if there a way i can do that through an if else statment??

here is the code so far....

<?php

if ($submit == "Setup")

{
$query = "insert into main
(content) values
('$request')"
;

mysql_query($query) or
die (mysql_error());

?>
index.php prepared for custom MOTD ... <font color=white>[<font color=green>OK</font>]</font>

<?php
}
else
{
include("failed.php");
}

ANY help at all well accepted .. thanks in advance