I have setup a login system on my site, in which the logged in user (user table) would be able to fill out an insurance form that’s saved in the database in a separate table – form_one table.
[B][U]user table
username – varchar(30), Null: No, Default: None – [B][I]Primary Key
password – varchar(32), Null: Yes, Default: NULL
userid – varchar(32), Null: Yes, Default: NULL
userlevel – tinyint(1), UNSIGNED, Null: No, Default: None
email – varchar(50), Null: Yes, Default: NULL
timestamp – int(11), UNSIGNED, Default: No, Default: None
valid – tinyint(1), UNSIGNED, Null: No, Default: 0
name – varchar(50), Null: Yes, Default: Null
[B][U]form_one table
formid – varchar(32), Null: No, Default: None – [B][I]Primary Key
username – varchar(30), Null: No, Default: None – [B][I]Foreign Key
email – varchar(50), Null: Yes, Default: NULL
phone – varchar(12), Null: No, Default: None
address – varchar(50), Null: No, Default: None
timestamp – int(11), UNSIGNED, Null: No, Default: None
name – varchar(50), Null: Yes, Default: NULL
quotationinsurance – enum(‘insurance’, ‘quotation’), Null: No, Default: None
etc…
[B][U]Below is my php function for UPDATE & SELECT
function updateUserForm($username, $field, $value){
/*$q = “UPDATE “.TBL_FORM_ONE.” SET “.$field.” = ‘$value’ WHERE username = ‘$username'”;[I]Original code
$q = “UPDATE “.TBL_USERS.”, “.TBL_FORM_ONE.” SET “.$field.” = ‘$value’ WHERE username = ‘$username'”;
return mysql_query($q, $this->connection);
}
function getUserForm($username){
/*$q = “SELECT */ – [I]Original code
$q = “SELECT
$result = mysql_query($q, $this->connection);
/* Error occurred, return given name by default
if(!$result || (mysql_numrows($result) < 1)){
return NULL;
}
How can I join these two tables where the username in both tables are tied together. In other words, once a user is logged in, they can fill out the form and the data from that form would be tied to each unique user.
Any help would be appreciated! 🙂