Work with joins

QuestionsWork with joins
Mateo asked 10 months ago

Hello. I’m currently working with a join. So heres the line :

$g->select_command = “SELECT * FROM pn_activemenu NATURAL JOIN pn_activemenulang_new”;

 

How to, with the form, insert into pn_activemenu some info and insert into pn_actumenulang_new others infos

1 Answers
Abu answered 9 months ago

Hello,

To insert in multiple tables, you need to run 2 queries, and this can be done by using on_insert event handler.

https://www.gridphp.com/docs/grid-events/

Above link contains details and related sample code link.

Abu Ghufran Staff replied 9 months ago

+ Events are supported in full or trial version. Not in free.
For trial: https://www.gridphp.com/download/
For full: https://www.gridphp.com/compare/

Your Answer

16 + 1 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?