[Resolved] Deleting and Inserting Data, not working

jdnet

Hi, I have a portion of text on my page that is stored in a MySQL database in the table picture_note. The code below is from my admin section, where i want to be able to type new text in my textarea that replace it with the current text in the table. It currently with my script just adds to it, its not deleting. Someone recommonded the UPDATE command but im lost, could someone please help me?

<?php 
if(isset($_POST['action'])){$action=$_POST['action'];}else{$action="";} 
if(isset($_POST['message'])){$message=$_POST['message'];}else{$message="";} 
if($action=="post") 
{ 
  $mysql_access=mysql_connect("xxx", "xxx", "xxx"); 
    mysql_select_db("pictures"); 
$mysql = 'DELETE FROM `picture_note` '; 
$mysql="insert into picture_note values('$message')"; 
mysql_query($mysql, $mysql_access); 
} 
?>

LordShryku

An update statement would have you doing this in one query.

UPDATE table
SET field = 'value'
(optional) WHERE field = 'value'

jdnet

ok i got it to work with no parse errors but its not effecting the database at all....its not updating as it should

$mysql = "UPDATE picture_note SET field = '$message' ";

LordShryku

Find out why....

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

jdnet

Ok, i assume where it says set field thats the varible i wanna insert into the table, but nonetheless i got:

Unknown column 'field' in 'field list'

LordShryku

field should be the name of the field in the database you want to change.

jdnet

yea, i want to update field "1" in that database, but it still gives me that same error, even when i put

$mysql = "UPDATE picture_note SET field = 1";

LordShryku

No, change the field part to the name of the field you want to update

jdnet

the name of the field in that table is "1"....so i assume im correct? I cant seem to figure out what is wrong....

LordShryku

You named your field "1"???

Anyway.

$mysql = "UPDATE picture_note SET `1` = '".$message."' ";
mysql_query($mysql);

jdnet

thanks alot, got it to work!