Data only going into 1 table

[Ell20]

Im having some trouble with putting data from a form into 2 seperate tables.

 

//Adds data into club table: club_id (auto increment), type of website and club name = working fine

$query1 = "INSERT INTO club (webtype, clubn) VALUES ('$membertype', '$clubn')";     

$result = @mysql_query ($query1);

 

//I also need to put club_id into the users table so getting the data from the clubs table

$sql = "SELECT * FROM club WHERE clubn='$clubn'";

$result = mysql_query($sql);

$clubdata = mysql_fetch_array($result);

 

$clubid=$clubdata['club_id'];

 

//This query here dosent insert anything into the table, no errors, just no data

$query2 = "INSERT INTO users (username, club_id, member_type, first_name, last_name, email, password) VALUES ('$username', '$clubid' 'Admin', '$fname', '$surname', '$email', '$pass1')";     

$result = @mysql_query ($query2);

}

 

Appreciate any help

 

Cheers

[Barand]

After inserting into club table, call mysql_insert_id() to get the club_id of new record.

 

Use that for the club_id when inserting user