[cebuy]

This maybe an elementary question to post in this forum, but I am stumped and need a bit of help (I am a newbie to php). I have 3 drop down fields in a form. Each drop down list is the same list of cities. I would first of all want to know how to go about saving the 3 fields as a comma seperated list in one mysql field. I am guessing that I cannot with just simple html since it would require a separate field in the mysql for each name ...and if I name them the same field name, probably only one would get listed in the mysql field. I think it will require php to merge them together.

Example...
<select size="1" name="City1">
<option>Atlanta</option>
<option>Athens</option>
<option>Rome</option>
<option>Thomasville</option>
</select>

<select size="1" name="City2">
<option>Atlanta</option>
<option>Athens</option>
<option>Rome</option>
<option>Thomasville</option>
</select>

Saved under Mysql Field 'city' as
"Athens,Rome"
instead of having to save as mysql field 'city1' = 'Athens' & 'city2' = 'Rome'

Any IDEAS?
Chris Chandler
Quoting Loans

[<?Wille?>]

PHP Code:

#to insert

// open db connection

$city = array($_POST['city1'], $_POST['city2'], $_POST['city3']);

$commaseparated = implode(',', $city);

mysql_query("insert into table set citys='$commaseparated'") or die('error: '.mysql_error());



# use

// open db

// fetch result

$citys = explode(',', $resultcityvar); 

hope it helps
Wille

[cebuy]

ok thanks. I will try that.

[<?Wille?>]

oh.. forgot to mention.. when you do what ever you do with the citys (echo etc.) the usage will be like this:

PHP Code:

# use 

// open db 

// fetch result 

$citys = explode(',', $resultcityvar);



echo $citys[0]; // outputs city1 value

echo $citys[1]; // outputs city2 value 

[cebuy]

ok, great! that is helping tremendously.