urlencode and drop down menu's

[stew]

hey guys...

im trying to process a form and insert the contents into my data base.

the contents of a drop down menu is retrieved from a table in the data base and appears good enough on the page, however when the form is processed, it's only the first word of the $artist variable that is inserted into the database.

if (!$result) { echo( mysql_error()); }
else {
while ($row = mysql_fetch_array($result)) {
$artist = $row["artist"];

echo ("<option value=$row[artist]>$artist</option>"); }

ive heard about the urlencode() function, but i cant seem to get it to work.

any ideas welcome

[bastien]

you need to place the single quotes around the value..see the changed statement below....

echo ("<option value='".$row[artist]."'>$artist</option>"); }

[stew]

worked like a charm... ta!

[twilson]

As a general rule I always use quotes around values because of the possible spaces.

Peace,
Tom