[RESOLVED] MySQL - INSERT from 1 form to 2 tables

[lelyea]

First - I appreciate the help I have received here - a lot! (Just in case I haven't said so.)

I am a student 11 weeks into a PHP/MySQL college class. The following week is spring break (no teacher) and I am working on my 'final project'.

I'm dealing with a registration form and inserting the data into two tables (customer info into one table, userid and password into another).

Currently, in my script I can insert data from the form in either table, but not in both tables. Here is what I have;

if ($isValid == 1) {
$query = "INSERT INTO mycustomer Values(null, '$fname', '$lname', '$address', '$address2', '$city', '$state', '$zip', '$email', '$phone')";

$query = "INSERT INTO authorized_users Values('$userid', '$pass1', null, '$secret', '$secretType')";

if(!mysqli_query($db, $query)){
	echo mysqli_error($db);
	}else{
	echo "<font><b>Data added to the database</b></font><br>";

    exit;
	}
}

I do not get an error - which sucks . . Either $query will work - (adds data to database) but with both it always skips the first . . .

I have scoured my book - PHP and MySQL Web Development, but don't see any similar examples.

I have an excellent teacher - I am a week or two ahead of the class.

As always - help is appreciated.

Thanks,

Len

[NogDog]

You are assigning a query string to $query twice in a row, so when you execute the mysqli_query() function you are only sending it the 2nd query string. You will therefore need two calls to mysqli_query():

$query = "blah blah blah";
mysqli_query($db, $query);
$query2 = "foo bar";
mysqli_query($eb, $query2);

The above is just to show the basic sequence of things -- I've left out the error-checking and such just to keep the example simple.

[lelyea]

Thanks again for the help. Of course, that worked!