PHP & Mysql

[june_c21]

hi, how to write php code where i called values from table 1 (database) and insert to table 2 (database) ?

 

thanks

june

[june_c21]

$month = $_POST ['month'];

$gf = $_POST ['gf'];

$equipment = $_Get ['equipment'];

 

 

 

$query= "INSERT INTO report( month,gf,equipment) VALUES ('$month','1','$equipment') ";

$result = mysql_query($query,$dblink);

 

 

my problem is the month & gf are insert by users to report table but equipment is taken from different table and want to insert into report table. how to write the code?

 

thanks

[june_c21]

i need help.......

[steve448]

If $equipment is taken from another table then you will need to do that sql query first and use the result as $equipment before your insert

[june_c21]

how to write the code for that? i still new with the query part.