INSERT into 2 tables of DB

[leeandrew]

Hi, when a user signs up their data is inserted into table `users`, i want to be able to have data inserted into another table simultaneously aswell, a table called `user_details`.

 

I have tried this but it isnt working:

 

// Connect to the host.
$link = OpenConnection();

$todaysDate = date("Y-m-d");
$query = "INSERT INTO $dbaseUserData (lid,username,password,email,icon,usertype,since) values ('$leagueID','$username','$encryptpass','$email','$icon','1','$todaysDate')";
$query2 = "INSERT INTO user_details (username,password,email) values ('$username','$encryptpass','$email')";
$result = mysql_query($query, $query2)
  or die("Query failed: $query, query2");

CloseConnection($link);

 

Can anyone help out, what is wrong with the code?

[papaface]

// Connect to the host.
$link = OpenConnection();

$todaysDate = date("Y-m-d");
$query = "INSERT INTO $dbaseUserData (lid,username,password,email,icon,usertype,since) values ('$leagueID','$username','$encryptpass','$email','$icon','1','$todaysDate')";
$query2 = "INSERT INTO user_details (username,password,email) values ('$username','$encryptpass','$email')";
$result1 = mysql_query($query)
  or die("Query failed: $query");
$result2 = mysql_query($query2)
  or die("Query failed: $query2");


CloseConnection($link);

[sasa]

or try

// Connect to the host.
$link = OpenConnection();

$todaysDate = date("Y-m-d");
$query = "INSERT INTO $dbaseUserData (lid,username,password,email,icon,usertype,since) values ('$leagueID','$username','$encryptpass','$email','$icon','1','$todaysDate');";
$query .= "INSERT INTO user_details (username,password,email) values ('$username','$encryptpass','$email');";
$result = mysql_query($query)
  or die("Query failed: $query");

CloseConnection($link);

[leeandrew]

cheers, it worked!