How to populate HTML dropdown list with values from database

by

My guess is that you have a problem since you don’t close your select-tag after the loop. Could that do the trick?

<select name="owner">
<?php 
$sql = mysqli_query($connection, "SELECT username FROM users");
while ($row = $sql->fetch_assoc()){
echo "<option value=\"owner1\">" . $row['username'] . "</option>";
}
?>
</select>

More Related Contents:

  1. to delete 14 row by 1 click
  2. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  3. how to get client’s IP address in sql database [closed]
  4. Combine multiple sql / mysql queries in one query
  5. PHP Parse Error – Creating a PHP script to verify user and pass [duplicate]
  6. Cleansing User Passwords
  7. Commands out of sync; you can’t run this command now
  8. Cannot simply use PostgreSQL table name (“relation does not exist”)
  9. SELECT COUNT(*) AS count – How to use this count
  10. Get table column names in MySQL?
  11. How to resolve ambiguous column names when retrieving results?
  12. selecting unique values from a column
  13. How to insert multiple rows from a single query using eloquent/fluent
  14. Simple PHP Pagination script [closed]
  15. Use bound parameter multiple times
  16. Create a dynamic mysql query using php variables
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. Laravel Eloquent, group by month/year
  19. Why does this return Resource id #2? [duplicate]
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. How to generate unique id in MySQL?
  22. Pass array literal to PostgreSQL function
  23. How to SELECT DEFAULT value of a field
  24. New containing div after every 3 records
  25. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  26. Log the actual SQL query using ActiveRecord with Yii2?
  27. How to check if a value already exists to avoid duplicates?
  28. MYSQL select a piece of a string and order by that piece
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment