multiple menu/list values inserted into one mysql column

[Nimotek]

Simple problem here for the pros I'm sure. I have constructed a "rockshow"
database in mysql for local music artists/bands and I made an input form in
Dreamweaver. The problem I'm having is how to merge values from two different
drop down menus/lists so that they can be inserted into the same column in the
shows table in my database. Ex. The first menu has time in half hour
increments (1:00, 1:30, 2:00 etc) and the second menu has "am, pm". I just
would like the two selected values to merge into "1:00 pm" so that it will
insert that way into the single column in the database table which is
"showtime". Thanks for any followups.

[-Rb]

"Nimotek" <webforumsuser@macromedia.com> wrote in message
news:cuv05u$rom$1@forums.macromedia.com...

> Simple problem here for the pros I'm sure. I have constructed a "rockshow"
> database in mysql for local music artists/bands and I made an input form in
> Dreamweaver. The problem I'm having is how to merge values from two
> different
> drop down menus/lists so that they can be inserted into the same column in
> the
> shows table in my database. Ex. The first menu has time in half hour
> increments (1:00, 1:30, 2:00 etc) and the second menu has "am, pm". I just
> would like the two selected values to merge into "1:00 pm" so that it will
> insert that way into the single column in the database table which is
> "showtime". Thanks for any followups.
>

Perhaps you could use the concatention operator ('.')

<?php
$a = "Hello ";
$b = $a . "World!"; // now $b contains "Hello World!"

$a = "Hello ";
$a .= "World!"; // now $a contains "Hello World!"
?>

The PHP documentation is available at:

< [url]http://www.php.net/docs.php[/url] >

HTH

-Rb