how to write the query to insert data in two different table but in one form

[weiwei]

i want to insert the data from html form to 2 database table. How is the query to be? any body can help me.How to combine two query below?

$query = "INSERT INTO listofitem(NamaPeralatan,Jenama,Motor,Operasi,Balai,Komunikasi) VALUES ('$NamaPeralatan','$Jenama','$Motor','$Operasi','$Balai','$Komunikasi')";

$query1 = "INSERT INTO iteminfomation (TahunDibekalkan,JenisPerolehan,Kuantiti,HargaPerUnit,KadHartaModel,Status,LokasiPenempatan) VALUES ('$TahunDibekalkan','$JenisPerolehan','$Kuantiti','$HargaPerUnit','$KadHartaModel','$Status','$LokasiPenempatan')";

[Piranha]

The answer is quite simple: It is not possible to insert into more than one table at a time. I haven't looked that good at your queries, but think they are ok as they are now.

[weiwei]

does i have another way to do that?

[Piranha]

The way you already do it: Do it like 2 queries. Just be sure to use the correct keys if one query is in a relationship to the other.