form php mysql problem

[matt121400]

ok so i am making a form and i need 1 text box from a form to produce 2 seperate entries into the mysql for example when someone picks a state from a drop down menu i would like it to send New York and NY as seperate fields in mysql how would i go about this? i was thinking hidden fields possibly but i am new at this so i am not quite sure how to go about it.

[TransmogriBenno]

Why do you want to do that?

 

I think a better solution would be to store the short (e.g. NY) and long (e.g. New York) names in, say, a 'States' table the database, and then reference them using a key. You could use the short name as the key.

[matt121400]

i have a program that needs it to do it the way i described so ya..

[vikramjeet.singla]

you may use as:

 

<option value="NY:New York">New York</option>

 

when you will store this in database just explode and save

 

enjoy

[$username]

What I do to make things fast for programing is add the states to a table in mysql.

 

Like this

StateFullName  |StateAb  |  StateID

ALABAMA       |AL     |  1

 

From there I just do a query on the tables and pull back what is needed.

<tr>
    <td><strong>State:</strong></td>
    <td>
       <select name=\"AccountState\" size=\"1\">";
          
$sql149 = "SELECT StateFullName, StateAb FROM states";

if ($result149 = mysql_query($sql149)) {
  while ($row149 = mysql_fetch_assoc($result149)) {
    $selected = ($row149['StateAb']==$Wisconsin)?" selected=\"selected\"":"";
   echo "<option value=\"{$row149['StateAb']}\"{$selected}>{$row149['StateFullName']}</option>";
  }
}

echo      " </select>
      </div></td>

     </tr>

[matt121400]

ok well my situation is kinda wierd im using a macro program and would like to pull the info from 1 table and some of the things the macro fills out has NY and MN and so on for their drop down menus and some have New york and Minnesota as the choices so what i would need is to have Mn in 1 colum and Minnesota in the next column as i am writing each sites macro individually and can pick and chose which column goes in which site anyway so ya that is why i need it

[TransmogriBenno]

You can do that with my solution with a JOIN. If you really want to store the two columns in the same table, then vikramjeet.singla already gave you the answer, eh?