This topic is locked

INSERT statement in PHP Runner

11/8/2012 9:09:12 PM
PHPRunner General questions
P
phpcmk author

Hi,
Can someone please kindly advise how can I user INSERT statement in PHP Runner?
I am trying to INSERT into a column name "creator" with user login id ($_SESSION[userid]).
The codes below seems not working.
-------------------------------------

Events>Add page>After record added

-------------------------------------------

global $conn;

CustomQuery ("INSERT INTO table_data (creator) VALUES ('$_SESSION[userid]') WHERE id=".$keys["id"]);

--------------------------------------------
Thanks

C
cgphp 11/9/2012
CustomQuery("INSERT INTO table_data (creator) VALUES ('".$_SESSION['UserID']."') WHERE id=".$keys['id']);