help with a mysql insert/override

krrose27

ok the value is already submit, but with this i wanna submit ver it ofcourse it isnt rite. can anyone help? you should be able to see what im trying to do.

mysql_query("INSERT into user_reports WHERE id = '$idnum'(status) VALUES ('$newstat')") or die (mysql_error());

Houdini

Not sure what ou are trying to do or ask but MySQL has three syntaxs for INSERT
they are;

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    VALUES ({expr | DEFAULT},...),(...),...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name
    SET col_name={expr | DEFAULT}, ...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    SELECT ...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ...

krrose27

oK im going to start running this site, and people can submit data. then my staff looks it over. and i want them to change the data in one field. is that possible so like:
1.Person submits data (the slot 'status' is auto set to 1)
2.Staff reviews and edits the status to (1,2,3) either of thewse. thats what i want that todo.

krrose27

here this is from the begning of the script


$idnum = $_GET['id'];
$newstat = $_POST['stat'];

pretty much im trying to insert over the field 'status' with the posted ammount in the select id.

Houdini

Something like

UPDATE user_reports SET status= {1, 2 or 3) WHERE id='something'

The braces are just there for illustration as in it could be set to one of those numbers and not knowing a lot about you table structure the UPDATE would change values in the table user_reports. The SYNTAX for UPDATE is

UPDATE [I]tablename[/I] SET [I]column = value, column = value ... [/I] WHERE clause

krrose27

thank you.