how to insert data into one form ,the form include 2 table data in database

weiwei

i had create a form and i want to insert the data, but my form was include the data from 2 table , wat will be the query looked like, can somebody give me the example ? How to do it?

vaaaska

SELECT * FROM your_table1,your_table2

weiwei

i am not very understand about wht did u mean, let say here is the 2 table that need to insert the data, how should i do, can u make it more clear?i am new in programing.

$query = "INSERT INTO listofitem (NamaPeralatan,Jenama) VALUES ('$NamaPeralatan','$Jenama')";

$query2="Insert into iteminformation(Price,Noreferense)VALUES('$Price,'$Noreference')

mysql_query($query ) or die('Error insert query failed')

vaaaska

$query = "INSERT INTO listofitem (NamaPeralatan,Jenama) VALUES ('$NamaPeralatan','$Jenama')";

$query2= "INSERT INTO iteminformation (Price,Noreferense) VALUES ('$Price,'$Noreference')";

mysql_query($query) or die ('Error insert query failed');
mysql_query($query2) or die ('Error insert query failed');

Are you getting error messages? Or, have you tried it yet...

weiwei

i had been try in this wy ut seen like not success, the only item in second query are insert , the first query become no function. How?

vaaaska

I'm sorry, I don't understand.

Are you getting error messages...and what are they?