I am trying to add the category (reception room) into a column called category but also add reception-room into a column called linkcategory.
I am struggling to add ‘reception room’ into both category and linkcategory column.
I also dont know where to add the stringreplace once I am entering reception room into both columns.
Does anyone have any suggestions please?
if(isset($_POST['form_id'])){
$category = mysql_real_escape_string(trim($_POST['category']));
$firstname = mysql_real_escape_string(trim($_POST['firstname']));
$surname = mysql_real_escape_string(trim($_POST['surname']));
$email = mysql_real_escape_string(trim($_POST['email']));
$website = mysql_real_escape_string(trim($_POST['website']));
$company = mysql_real_escape_string(trim($_POST['company']));
$building = mysql_real_escape_string(trim($_POST['building']));
$streetname = mysql_real_escape_string(trim($_POST['streetname']));
$state = mysql_real_escape_string(trim($_POST['state']));
$postcode = mysql_real_escape_string(trim($_POST['postcode']));
$country = mysql_real_escape_string(trim($_POST['country']));
$aboutcompany = mysql_real_escape_string(trim($_POST['aboutcompany']));
$error = false;
if(!isset($category) || empty($category)) {
$error = "Please select a category.";
}
if(!isset($firstname) || empty($firstname)) {
$error = "Please enter a First Name.";
}
if(!isset($surname) || empty($surname)) {
$error = "Please enter a Surname.";
}
if(!isset($email) || empty($email)) {
$error = "Please enter an email.";
}
if(!isset($website) || empty($website)) {
$error = "Please enter a Website Domain.";
}
if(!isset($company) || empty($company)) {
$error = "Please enter a Company Name.";
}
if(!isset($building) || empty($building)) {
$error = "Please enter a Building Name or Number.";
}
if(!isset($streetname) || empty($streetname)) {
$error = "Please enter a Street Name.";
}
if(!isset($state) || empty($state)) {
$error = "Please enter a State.";
}
if(!isset($postcode) || empty($postcode)) {
$error = "Please enter a Zip Code/Post Code.";
}
if(!isset($country) || empty($country)) {
$error = "Please select your country.";
}
if(!isset($aboutcompany) || empty($aboutcompany)) {
$error = "Please enter details about your company.";
}
if(!$error) {
$query = mysql_query("INSERT INTO organiserdbase (category, category, firstname, surname, email, website, company, building, streetname, state, postcode, country, aboutcompany) VALUES ('".$category."', '".$linkcategory."', '".$firstname."', '".$surname."', '".$email."', '".$website."', '".$company."', '".$building."', '".$streetname."', '".$state."', '".$postcode."', '".$country."', '".$aboutcompany."')");
if($query) {
} else {
$error = "There was a problem with the submission. Please try again.";
}
}
}