2. PHPRunner General questions
  3. inner join multiple tables
This topic is locked

inner join multiple tables

 		6/7/2007 9:59:33 PM
PHPRunner General questions
M
 mr.jim author

hi all,

sorry me for my english, i am jim in germany
i read that phprunner support view for inner join tables but dont support add/edit joined tables (more then one table), is that true? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5454&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
how can i edit or add record of multiple tables of inner join?
please help me, I new to php/mysql
thank you,
jim
Admin 6/8/2007

Jim,
PHPRunner doesn't support updating multiple tables on one page.

You can implement this manually using Before record updated/added events.
I.e. use something like this:

global $conn;

$sql = "update othertable set joinedfield=".$vales["joinedfield"]." ... ";

db_exec($sql,$conn);

unset($vales["joinedfield"]);
M
 		mr.jim author 6/8/2007

where should i put this code so that i will not get error when i edit/add values from joined tables?
and i know the name of the fields but i don't know from where i can get the values the name of elements in the page.
what is this? unset($vales["joinedfield"]);
is there a demo of live example of joined tables where edit and add pages are working ok?
sorry me i am new and really want to use this tool <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=18670&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
jim