Professional Web Applications Themes

multiple menu/list values inserted into one mysql column - Dreamweaver AppDev

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 ...

  1. #1

    Default multiple menu/list values inserted into one mysql column

    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.

    Nimotek Guest

  2. #2

    Default Re: multiple menu/list values inserted into one mysql column


    "Nimotek" <webforumsusermacromedia.com> wrote in message
    news:cuv05u$rom$1forums.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 doentation is available at:

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

    HTH

    -Rb

    -Rb Guest

Similar Threads

  1. Mail values from a List with Multiple Selections with PHP
    By Freebeeezz in forum Dreamweaver AppDev
    Replies: 2
    Last Post: April 13th, 07:23 PM
  2. submit multiple values from a list box PHP
    By DennisMcDougall in forum Adobe Dreamweaver & Contribute
    Replies: 3
    Last Post: March 6th, 02:58 AM
  3. Sum a column of values from a MySQL query
    By Ben C. in forum PHP Development
    Replies: 3
    Last Post: August 5th, 03:37 PM
  4. [PHP] Sum a column of values from a MySQL query
    By Ben C. in forum PHP Development
    Replies: 8
    Last Post: August 5th, 01:50 PM
  5. Selecting Multiple Values in a List/Combo Box
    By June Macleod in forum Microsoft Access
    Replies: 0
    Last Post: July 21st, 05:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139