[Resolved] Insert data into multiple tables - newbie

dee7

i have several tables, two of which are ApplicantDetails and ContactInformation. how do i build a query to insert data from input forms into these tables?

i tried:

$query = "insert into PersonalDetails
(Title, Gender, FamilyName, PreviousFamilyName, FirstNames, Nationality) values
('".$Title."', '".$Gender."', '".$FamilyName."', '".$PreviousFamilyName."',
'".$FirstNames."', '".$Nationality."')";

$query = "insert into ContactInformation
(Address1, Address2, Town, County, Postcode, Country, Email, DaytimePhone ) values
('".$Address1."', '".$Address2."', '".$Town."', '".$County."', '".$Postcode."',
'".$Country."', '".$Email."', '".$DaytimePhone."')";

but its only inserting into the ContactInformation table.

Help!!

stolzyboy

call one query_one and the other query_two, then use two different mysql_query()'s with each one

<?
$query_one = "insert into firsttable.....;";
$query_two = "insert into secondtable.....;";

$result_one = mysql_query($query_one) or die(mysql_error());
$result_two = mysql_query($query_two) or die(mysql_error());
?>

dee7

thanks a lot. that worked fine.

if u don't mind, some other questions (in order of priority):

how do i use hidden fields to transfer data in multipage forms?

how can i check my database to ensure that a user does not submit same form twice but update if the data has changed?

when using 'LIMIT' with 'SELECT' in queries, how can i have an initial, say 10 rows, and then present a button (or whatever) for the user to see the next 10 rows?