copy data from a column in table a into a column in table b!

[jcrensha627]

I have a column called price in table a. and a column called price in table b - I am trying to figure how to make the column in table b be populated by the column in table a.

EXAMPLE

TABLE A TABLE B

price price
=== ===
50 (here i want the 50 from table a to appear automatically)

[PhPHelper]

after the price is put into table A run another query right after to insert into table B