2. PHPRunner General questions
  3. [SOLVED]  After Record Added
This topic is locked
[SOLVED]

 After Record Added

 		3/21/2013 5:40:44 AM
PHPRunner General questions
C
 chcp author

Hello,

Is it possible in After record added to execute a command with sql function? For example

//********** Insert a record ************

global $conn;
$strSQLInsert = "INSERT INTO zoznam_zakaznik_oddelenie (zoznam_zakaznik_oddelenie_zoznam_oddeleni_nazov_nazov_zakaznika)

SELECT CONCAT(zoznam_oddeleni.zoznam_oddeleni_nazov, "_", zoznam_zakaznikov.zoznam_zakaznikov_nazov)

FROM zoznam_oddeleni

, zoznam_zakaznikov

, zoznam_zakaznik_oddelenie

WHERE zoznam_oddeleni.id_zoznam_oddeleni = zoznam_zakaznik_oddelenie.zoznam_zakaznik_oddelenie_id_zoznam_oddeleni

AND zoznam_zakaznikov.id_zoznam_zakaznikov = zoznam_zakaznik_oddelenie.zoznam_zakaznik_oddelenie_id_zoznam_zakaznikov";

db_exec ($strSQLInsert, $conn);
Sergey Kornilov admin 3/21/2013

Yes, this code will work if your SQL query is correct. Make sure to test it outside of PHPRunner first.
C
 		chcp author 3/22/2013

Thank you Sergey,

I tested it outside of PHPRunner, and it works. I, try to insert into PHPRunner.