How can I enter data in multiple table in PHP using $result ?

Answer 1

Ok, so I just took the liberty of scratching down the inner and outer statements with the php code to it. Just for you. Be kind and take a look at them in my profile's codes-section. :-)
Is this what you were asking for?

Answer 2

No problem.

Do you want to use with or without SQL join statements?
You and I will deal with this in no time. :-)

Answer 3

Did you find what you were looking for? Or do you want me to keep the scripts on there a little longer? just comment or rate the codes on my profile when you are done with them. :)

Answer 4

Roger that. A moment please :)

Answer 5

SELECT tbl_a.column1 , tbl_a.column2
tbl_b.column1 , tbl_b.column2

FROM tbl_a INNER JOIN tbl_b
ON tbl_a.commonfield=tbl_b.commonfield

SELECT tbl_a.column1 , tbl_a.column2
tbl_b.column1 , tbl_b.column2

FROM tbl_a LEFT OUTER JOIN tbl_b
ON tbl_a.commonfield=tbl_b.commonfield

Answer 6

with sql @Coding

Answer 7

@Coding
Umm i guess this is nt what I'm looking for.
suppose we have tables table1(fname, lname) and table2(fname). we have to store $a in both fname and $b in table1's lname only.
How would you insert this?

Answer 8

sure sir😉@Coding