Displaying specific information from 1 SQL SELECT query

Question

I have a database table that contains a bunch of different options and their values. The table has 3 columns which are ID, menu_option, and value. So one row may have the following information: 1, "menu_color", "#AB324B".

I want to display the value of each option on the page so the user can edit the option. Right now, i'm creating a query to get the info for each specific option. Like so

SELECT * FROM menu_theme WHERE ID='1'
SELECT * FROM menu_theme WHERE ID='2'
SELECT * FROM menu_theme WHERE ID='3'
...

Instead of making a new query to get the info per row, how can I make 1 query and distinguish what row I want to get the data from and display the data using php?

I'm aware of how to use php while loops with an SQL query, but I can't see how that would work with selecting specific rows.

Jacob · Accepted Answer · 2013-11-14 03:44:58Z

3

Maybe something like this

 SELECT * FROM menu_theme WHERE ID IN ('1','2','3')

answered Nov 14, 2013 at 3:44

Jacob

9206 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Greg · Accepted Answer · 2013-11-14 03:55:36Z

1

maybe something like this:

<?php
//select all the rows
$sqlSelect="SELECT ID,menu_option,value FROM menu_theme";
$result=mysqli_query($con,$sqlSelect);
while($row=mysqli_fetch_array($result))
{
    $id=$row['ID'];
    $opt=$row['menu_option'];
    $val=$row['value'];

    $menuId="input-".$id;

    //create the label for the input
    echo "<label for='".$menuId."'>".$opt."</label>";

    //pre-populate the input with the name,value,id
    echo "<input type='text' name='".$menuId."' id='".$menuId."' value='".$val."'/>";
}

?>

answered Nov 14, 2013 at 3:55

Greg

6276 silver badges7 bronze badges

1 Comment

Josh Woelfel Over a year ago

Thanks, this should actually work fine. I'll use this method.

Collectives™ on Stack Overflow

Displaying specific information from 1 SQL SELECT query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related