This topic is locked

amend add page

6/11/2008 5:38:50 AM
PHPRunner General questions
E
echo author

hi. in addition to adding items to a db i also need the ability to retrive items from the db. i have tried the following code:
[codebox]//$id = $_POST['editid1'];

$_SESSION['retrive'] = $_POST['editid1'];

//echo $_SESSION['id'];

global $conn;

$query = "UPDATE items SET status = '9' WHERE id_frm = ".$_SESSION['id'];

db_exec($query,$conn);

return true;[/codebox]
which throws an sql error because the add page is trying to insert the record. can the add page be modified to achieve this function? many thanks

E
echo author 6/11/2008

found another way. thanks