Dropdown list only half transfering into database 1

likelylad · Nov 6, 2002

I have this form that contains about 13 fields.
Whn I hit submit all the information is transfered in a MySQL database.

I am having a small problem!!!!!!!!!!!!!!!
3 of the fields are dropdown lists.
Only some of the information from the dropdown lists is being transfered into the database. All the other fields are transfering over as expected.
For example, one of the lists contains names. If I select Michael Mouse, then only Michael is transfered across. It is only transfering the information up to the 'space' character.

Can anyone give me any clues

Thanking you in advance for any help received.

sleipnir214 · Nov 6, 2002

Are you putting quotes around your values in your option tags? ______________________________________________________________________
TANSTAAFL!

likelylad · Nov 6, 2002

This is the relevent code I am using.
As I said before, the dropdown list works perfectly.
I can manually type the name into the MySQL Database.

<html>
<body>
<form method="post" action="

http://server/folder/file.php">

<?php
$db = mysql_connect("server", "root", "&quot

or die;
mysql_select_db("names",$db) or die;
$sql='SELECT Entered_By FROM enteredby';
$result = mysql_query($sql,$db);
echo "<select name=entered_by>";
while ($row = mysql_fetch_array($result)) {
echo "<option value=$row[0]>$row[0]</option>\n";
}
echo "</select>\n";
?>
<input type="Submit" name="submit">
</form>

<?php

if(isset($_POST[submit])){

$db = mysql_connect("server", "root&quot

;

mysql_select_db("input",$db);

$sql1 = "INSERT INTO information (Entered_By) VALUES ('$_POST[entered_by]')";

$result1 = mysql_query($sql1);

echo "Thank you! Information entered.\n";
}
?>
</body>
</html>

Bastien · Nov 6, 2002

back to sleipnir's question? are you putting quotes arund the values in the option box? ANSWER : NO....

change the option echo statement to this:

echo "<option value=\'".$row[0]."\'>$row[0]</option>";

the '\n' is not needed as options automatically are displayed on the next line...

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

sleipnir214 · Nov 6, 2002

Thank you Bastien.

likelylad, in the fora you can help yourself a lot by answering questions as well as asking them. ______________________________________________________________________
TANSTAAFL!

likelylad · Nov 7, 2002

Hi sleipnir/Bastien

Thanks for getting back to me.
Yes you were correct in guessing that there were no quotes in the values in the options box.

Bastien, I had to tweak the code you supplied a minor bit to get it to work. Please see below

echo "<option value='$row[0]'>$row[0]</option>";

Thanks very much for your help

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Dropdown list only half transfering into database 1

likelylad

IS-IT--Management

sleipnir214

Programmer

likelylad

IS-IT--Management

Bastien

Programmer

sleipnir214

Programmer

likelylad

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor