Ok so I think this is easy but I dont know (I'm a novice to PHP and MySQL).
I have a select that is getting data from a table in the database. I am simply taking whatever
options the user selects and putting it into a separate table with a php mysql insert statement.
But I am having a problem. When I hit submit, everything is submitted properly except for any select
options that have spaces don't submit after the first space. For example if the option was COMPUTER REPAIR, all that would get sent is COMPUTER. I will post code if needed, and any help would be greatly appreciated. Thanks!
Ok here is my select code:
<?php
include("./config.php");
$query="SELECT id,name FROM category_names ORDER BY name";
$result = mysql_query ($query);
echo"<div style='overflow:auto;width:100%'><label>Categories (Pick three that describe your business)</label><br/><select name='select1'><option value='0'>Please Select A Category</option>";
// printing the list box select command
while($catinfo=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option>$catinfo[name]</option><br/>
";
}
echo"</select></div>";
?>
And here is my insert code ( Just to let you know its got everything not just the select!)
?php
require("./config.php");
$companyname = mysql_real_escape_string(addslashes(trim($_REQUEST['name'])));
$phone = mysql_real_escape_string(addslashes($_REQUEST['phone']));
$zipcode = mysql_real_escape_string(addslashes($_REQUEST['zipcode']));
$city = mysql_real_escape_string(addslashes($_REQUEST['city']));
$description = mysql_real_escape_string(addslashes($_REQUEST['description']));
$website = mysql_real_escape_string(addslashes($_REQUEST['website']));
$address = mysql_real_escape_string(addslashes($_REQUEST['address']));
$other = mysql_real_escape_string(addslashes($_REQUEST['other']));
$payment = mysql_real_escape_string(addslashes($_REQUEST['payment']));
$products = mysql_real_escape_string(addslashes($_REQUEST['products']));
$email = mysql_real_escape_string(addslashes($_REQUEST['email']));
$select1 = mysql_real_escape_string(addslashes($_REQUEST['select1']));
$select2 = mysql_real_escape_string(addslashes($_REQUEST['select2']));
$select3 = mysql_real_escape_string(addslashes($_REQUEST['select3']));
$save=$_POST['save'];
if(!empty($save)){
$sql="INSERT INTO gj (name, phone, city, zipcode, description, dateadded, website, address1, other2, payment_options, Products, email,cat1,cat2,cat3)
VALUES
('$companyname','$phone','$city','$zipcode','$description',curdate(),'$website','$address','$other','$payment','$products','$email','$select1','$select2','$select3')";
if (!mysql_query($sql,$link))
{
die('Error: ' . mysql_error());
}
echo "<br/><h2><font color='green' style='font-size:15px'>1 business added</font></h2>";
mysql_close($link);
}
?>
