rootKID Posted December 18, 2014 Share Posted December 18, 2014 (edited) Well i think the title should say it all to be honest, i have a database with a table and a coble of rows in there. There is one of the rows that has "ENUM" as type and this "Højre" is default on the "ENUM" and has following options in it "Højre, Venstre". Now my question is, what shall i do to make this enum work in a "<select>" html? This is my code atm: echo "<select name='info_side'>"; echo "<option value='0'>Vælg Genre</option>"; $info_side_query = "SELECT dsg_id_runner, dsg_info_side FROM dataskema_generator WHERE dsg_id_runner = $caller"; $info_side_result = $mysqli->query($info_side_query); while ($row = $info_side_result->fetch_assoc()) { echo "<option value='" .$row['dsg_info_side']."'>" .$row['dsg_info_side']."</option>"; }echo "</select>"; And yes i know the value in there should be numeric, but the insert HAS to be a "Højre, Venstre" string? Right Oo? Hoping an answer soon ^^' Thanks! Edited December 18, 2014 by rootKID Link to comment Share on other sites More sharing options...
justsomeguy Posted December 18, 2014 Share Posted December 18, 2014 I'm not sure I understand your question. Are you looking for a query to list the possible values for an enum field? Link to comment Share on other sites More sharing options...
adam12 Posted March 25, 2022 Share Posted March 25, 2022 (edited) I searched and was hoping to find the answer to this question myself. Perhaps the OP has solved his own problem. I have the same question. I have a table with an enum field named device with set values of 'Computer', 'Laptop', 'Smartphone' etc so how do I create a dropdown selection input list in an HTML to display the options and a previously selected (stored in MySQL) option in that list? Edited March 25, 2022 by adam12 Link to comment Share on other sites More sharing options...
Ingolme Posted March 25, 2022 Share Posted March 25, 2022 Usually, since the enum field has a small number of options and they never change, you just need to hardcode the options instead of trying to get a list of all of them from the database. To select an option in a dropdown based on the data from a database query, you just need to check whether the value from the database is equal to the value of the dropdown option. <?php $row = query->fetch(); // Code to get a database row from a query $options = [ 'Computer', 'Laptop', 'Smartphone' ]; ?> <select name="device"> <?php foreach($option as $option) { // Select the option if the row matches it // I'm assuming your database has a field named "device" which stores the ENUM value. $selected = ''; if($option == $row['device']) { $selected = ' selected' } // Write the HTML code for the option echo "<option value='{$option}' {$selected}> {$option} </option>"; } ?> </select> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now