How do I set the selected item in a drop down box

by

You need to set the selected attribute of the correct option tag:

<option value="January" selected="selected">January</option>

Your PHP would look something like this:

<option value="January"<?=$row['month'] == 'January' ? ' selected="selected"' : '';?>>January</option>

I usually find it neater to create an array of values and loop through that to create a dropdown.

More Related Contents:

  1. How can I properly use a PDO object for a parameterized SELECT query
  2. MySQL: Select Random Entry, but Weight Towards Certain Entries
  3. How to populate second dropdown based on selection of first dropdown using jQuery/AJAX and PHP/MySQL?
  4. Notice: Array to string conversion in
  5. Selecting all columns that start with XXX using a wildcard?
  6. SELECT COUNT() vs mysql_num_rows();
  7. Select from mysql table WHERE field=’$array’?
  8. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  9. Selecting all fields except only one field in mysql [duplicate]
  10. select within 20 kilometers based on latitude/longitude
  11. MySQL ORDER BY rand(), name ASC
  12. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  13. How to properly set up a PDO connection
  14. Using PHP 5.5’s password_hash and password_verify function
  15. Search with comma-separated value mysql
  16. How to do this in Laravel, subquery where in
  17. PHP MySQLI Prevent SQL Injection [duplicate]
  18. mysql PDO how to bind LIKE
  19. Does mysql_real_escape_string() FULLY protect against SQL injection?
  20. Recursive categories with a single query?
  21. Why does this return Resource id #2? [duplicate]
  22. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  23. Password_Hash not working on my PHP login
  24. Formatting an SQL timestamp with PHP
  25. Finding free blocks of time in mysql and php?
  26. Using utf8mb4 with php and mysql
  27. how do I get month from date in mysql
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment