2. PHPRunner General questions
  3. [SOLVED]  insert a record
This topic is locked
[SOLVED]

 insert a record

 		3/15/2012 6:28:12 PM
PHPRunner General questions
author

I'm using ver 6 I want to insert group = manager in my table when I add a event.
//insert in another record Plan Holders

global $conn;

$strSQLInsert = "insert into Plan Holders (email, projectname, group) values ('" . $values["email"] . "','" . $values["projectname"] . "manager" . "')";

db_exec($strSQLInsert,$conn);
doesn't work. it ignores my "manager" what should I be using?
C
 		cgphp 3/15/2012

Fixed:

//insert in another record Plan Holders

global $conn;

$strSQLInsert = "insert into `Plan Holders` (email, projectname, group) values ('" . $values["email"] . "','" . $values["projectname"] . "','manager')";

db_exec($strSQLInsert,$conn);
501409 3/15/2012

thanks