insert into 2 tables? HOW?

aoz

I have a page where users register and I have now downloaded the phpbb2 forum.

The thing I want now is when the visitor register with desired username and password this data also will be written to the phpbb2's table.

this is my code :

function addUser($uid, $pwd, $picurl, $sex, $com, $kat, $self, $datecreated)
{
	$sql = "insert into user (uid, pwd, picurl, sex, com, kat, selfvote, datecreated) values ('" . AddSlashes($uid) . "','" .
		AddSlashes($pwd) . "','" . AddSlashes($picurl) . "','" . $sex . "','" . $com . "','" . $kat . "'," . $self . ", now())";
	$connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
	mysql_select_db(SQL_DB, $connection);
	mysql_query($sql);
	$sql = "select * from user where uid='" . AddSlashes($uid) . "' and pwd='" . AddSlashes($pwd) . "'";
	$query = mysql_query($sql);
	$rows = mysql_num_rows($query);
	if ($rows > 0)
	{
		$record = mysql_fetch_array($query);
		return $record["id"];
	}
	return 0;
}

So how do I do to insert the $uid and $pwd into table phpbb_users ?? how and where shall I place the code?

diego25

Change $sql so that it inserts into phpbb_users and call mysql_query with that new $sql again.

Diego

aoz

mmhh, can you give an example?
im kind of a n00b and dont really get it how you mean

diego25

$sql = "INSERT INTO phpbb_users etc";
mysql_query($sql);

Diego

aoz

I think you have missunderstood me (?)

That I did know. But I want the existing sql-query there AND add so it inserts into the other table too. In other words I want to insert into two tables at the same time. How do I do this?

currently code for just to insert in table user

function addUser($uid, $pwd, $picurl, $sex, $com, $kat, $self, $datecreated)
{
	$sql = "insert into user (uid, pwd, picurl, sex, com, kat, selfvote, datecreated) values ('" . AddSlashes($uid) . "','" .
		AddSlashes($pwd) . "','" . AddSlashes($picurl) . "','" . $sex . "','" . $com . "','" . $kat . "'," . $self . ", now())";
	$connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
	mysql_select_db(SQL_DB, $connection);
	mysql_query($sql);
	$sql = "select * from user where uid='" . AddSlashes($uid) . "' and pwd='" . AddSlashes($pwd) . "'";
	$query = mysql_query($sql);
	$rows = mysql_num_rows($query);
	if ($rows > 0)
	{
		$record = mysql_fetch_array($query);
		return $record["id"];
	}

How do i change the code so it still inserts data into table user but ALSO into table phpbb_users ???

diego25

Add my code at the bottom of your code. So it'll call mysql_query twice; once for each table.

Diego