php dropdown selection Inserts only the first word in the table
<pre><code>&lt;center&gt;&lt;?php
            include "config.php"; // Database connection using PDO

            //$sql="SELECT name,id FROM student"; 

            $sql="SELECT Product_Name, id FROM stockcount"; 

            /* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */
            ?&gt;
            &lt;select id = 'ProductName' name='productName' onchange="" &gt;Product_Name &lt;/option&gt;"
            &lt;?php
            foreach ($conn-&gt;query($sql) as $row){//Array or records stored in $row

                echo "&lt;option value=$row[Product_Name]&gt;$row[Product_Name
                ]&lt;/option&gt;"; 

                /* Option values are added by looping through the array */ 

            }
              ?&gt;
             &lt;/select&gt;
             &lt;/center&gt;&lt;p&gt;&lt;/P&gt;
</code></pre>

<p>This code shows all the product names from the stockcount table.</p>

<pre><code>&lt;?PHP

include ('config.php');

$date = $_POST['date'];
$productname = $_POST['productName'];
$cartons = $_POST['cartons'];
$send_to = $_POST['send_To'];



$sql = "INSERT INTO storerequest (Date, Product_Name, Cartons, Send_To) VALUES ('$date','$productname', '$cartons', '$send_to')";


if ($conn-&gt;query($sql)===TRUE) {

        header("Location:orderrequest.php");
}

else {

    echo "Error is " .$sql."&lt;br&gt;". $conn-&gt;error;

}

$conn-&gt;close();

?&gt;
</code></pre>

<p>This adds the selection from the dropdown to the storerequest table.</p>

<p>Now the problem is if i select an option named "Motor Car" from the down. It inserts in the storerequest table as "Motor" only. When i changed the product name to "Motor-Car" then it inserts as "Motor-Car". It basically stores only the 1st word. Please experts help me solve this problem</p>