here is the code:
Code: Select all
mysql_query("INSERT INTO agent_login (agentID, user_name, pass_word, company, F_name, M_name, L_name, email, my_indust, address,
suite, city, state, zipcode, country, C_phone_1, C_phone_2, C_phone_3, M_phone_1, M_phone_2, M_phone_3, Fax_1, Fax_2, Fax_3, Extension)
VALUES ('', '$user_name', '$pass_word', '$company', '$F_name', '$M_name', '$L_name', '$email', '$my_indust', '$address',
'$suite', '$city', '$state', '$zipcode', '$country', '$C_phone_1', '$C_phone_2', '$C_phone_3', '$M_phone_1', '$M_phone_2',
'$M_phone_3', '$Fax_1', '$Fax_2', '$Fax_3', '$Extension' ) ") or die(mysql_error());
$query = "UPDATE agent_login SET mem_since = CURDATE() WHERE agentID = '$agentID'";
mysql_query($query) or die(mysql_error());Please show me the error of my ways.
Thanks in advance,
Batoe