mysql with drop down menu

[czukoman20]

I have this drop down menu, and i want it to be able to look at what the user has in the database, and then i would like it to show up in the drop down as the default when the user goes into edit account

 

<tr><td>Type of Market:</td>
  <td><label>
    <select name="type_market" id="type_market">
      <option value="sto">Stocks </option>
      <option value="com">Commodities</option>
      <option value="edu">Education</option>
      <option value="fin">Financial Planning</option>
      <option value="mort">Mortgages</option>
              </select>

I want to make this take this value

<? echo $req_user_info['type_market']; ?>

kinda like how you would insert the text that they already have in the text box, but instead for a drop down menu

 

also just a side question.. What mysql query can i use to update a whole column in the database to = 0

 

help is appreciated thanks

[hitman6003]

Have a check for the value in the row for each item in the select:

 

<option value="sto" <?php echo $req_user_info['type_market'] == "sto" ? 'selected="selected" : ''; ?>>Stocks </option>

[quote]What mysql query can i use to update a whole column in the database to = 0[/quote]

Don't use a WHERE clause...

[code]UPDATE table_name SET column = 0;

[/code]

[czukoman20]

thanks

 

[czukoman20]

<option value="sto" <?php echo $req_user_info['type_market'] == "sto" ? 'selected="selected" : '; ?>>Stocks </option>

i get an error message saying that the semicolon is an issue. if its there or isn't there

 

[hitman6003]

You have some misplaced single quotes.

 

Also, it may help to put the expression in parenthesis:

 

<?php echo ($req_user_info['type_market'] == "sto" ? 'selected="selected"' : ''); ?>

[czukoman20]

thanks that worked..

ok well one last question

mysql_query("");

 

What should i input if i want to delete all information from a particular column but still keep the column

 

[Stephen]

You could try doing:

mysql_query("UPDATE table SET column=''");

[czukoman20]

ok well i figured it out