Registration Page: Writing 2 MySQL queries into 1 PHP variable

Question

I am looking for a way to write 2 MySQL queries into 1 PHP variable since I am looking to insert into 2 different tables.

I am building a simple registry page where the name is in table "users" and email and password is in table "auth".

Tables as follows:

table users table auth

so I thought something like this:

$sql = "INSERT INTO users VALUES('', '$name','','') INSERT INTO auth VALUES('', '', '$email', $password', '')";

since I am using

$result = mysql_query($sql); 

I would need to have the query in one variable ($sql) as far as I understand.

Thanks.

Answer 1

If the two tables are related, a straightforward insert will put the data in no problem. Then just get your data into a $result variable.

SELECT username, auth
FROM users
INNER JOIN auth
ON users.id=auth.id;

Answer 2

Just add ; to sql query to execute double query

$sql = "INSERT INTO users VALUES('', 'name');INSERT INTO auth VALUES('', '', '$email', $password', '')";