Mysql table data into a drop down list

k994519

Hi guys

quick question

How can i get mysql table data into a drop down list ,

any tips which you have used.........

as ever your help is much appriecate.....

obviously I would call the <input type.......... stuf in

rebelo

Your description is really vague, so my answer might not be on target, but if you want to get data from a mysql database and then list the results in a SELECT form field, you would do something like this:

<select name="something">

<?php
// modify this query to fit your needs
$query = "SELECT * FROM table WHERE 1";
$result = mysql_query($query);

if (mysql_num_rows($result)) {
    // loop through resulting rows, creating options
    while ($row = mysql_fetch_row($result)) {
        echo "<option value=\"".$row[0]."\">".$row[1]."</option>";
    }
}
?>

</select>

k994519

HI rebelo

Ive got a table which holds information about different courses a user can take...... what i need is the data in the field to be outputed in into a drop down box.....

this is my query so far....


$query = "SELECT subject_code  FROM subject info WHERE subject_code=!null; 
$result = mysql_query($query); 

if (mysql_num_rows($result)) { 
    // loop through resulting rows, creating options 
    while ($row = mysql_fetch_row($result)) { 
        echo "< input type ="ist" list value=\"".$row[0]."\">".$row[1]."</option>"; 
    } 
} 
?>

this is not working
any tips?

rebelo

Well, your code is riddled with syntax errors. You need to check all your quotes.