I'm trying to make a webpage, that loads the info from my database, that works fine, and putting info in the database with my self made php works too. But i only want one row, so if i put new info in the database it overwrites the old info.

I read on the mysql page i have to use this:

code:

---

mysql> INSERT INTO table (a,b,c) VALUES (1,2,3)
    -> ON DUPLICATE KEY UPDATE c=c+1;
mysql> UPDATE table SET c=c+1 WHERE a=1;

---

INSERT is just adding a new record into the table.
UPDATE refreshes the table in the database file.
Then again, I'm not overly familiar with MySQL...

i think you just need to use UPDATE instead of INSERT, as INSERT makes a new record each time

u mean i just use this?:

code:

---

UPDATE INTO table (a,b,c) VALUES ('$1','$2','$3')

---

code:

---

UPDATE `table name` SET `column 1` = 'value 1',
`column 2` = 'value 2',
`value 3` = 'value 3' WHERE `id` = '1' LIMIT 1 ;

---

quote:

---

Originally posted by saralk
have a column called id, put one record in it, with the ID as 1, and then just run that script every time you want to update it

---

I want to post info from a form am i doing it right like this?

code:

---

$sql= "UPDATE molly SET inhoud = $_POST['inhoud']";
mysql_query($sql) or die (mysql_error());

---

code:

---

<?

include_once('connection.inc.php');
opendb();

$sql= "UPDATE 'molly' SET 'inhoud' = '$_POST['inhoud']'";
mysql_query($sql) or die (mysql_error());

?>

---

code:

---

<?

include_once('connection.inc.php');
opendb();

$_POST['inhoud'] = addslashes($_POST['inhoud']);
$sql= "UPDATE molly SET inhoud = '{$_POST['inhoud']}'";
mysql_query($sql) or die (mysql_error());

?>

---

It works, thank you very much

But when I show this on a page things with a ' in them show like this: \'things'\, how do I correct this?

EDIT: Nevermind, i found the stripslashes function

quote:

---

Originally posted by Ezra
But when I show this on a page things with a ' in them show like this: \'things\'

---