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