Question regarding implementing mysql/php into an html table

[axman288]

Hello. I'm fairly new to mysql/php programming... so I'm not sure how to even start with what I want to accomplish.

Basically... I want to create a page that would allow users to upload "digital notes" based on subject. The user would select a "subject" to accompany the note. In addition to uploading the note, the submission would add the subject to a subject database. If the subject already exists, the user could have selected it from a drop down <select> menu instead.

Is it possible to populate a <select> field in a form with mysql data? And if so how?

I know SELECT * FROM 😃ATABASENAME: WHERE ectect. can get mysql data, but was unsure if you could design a while statement to populate <select> fields with mysql data.

Any advice you can give me would be great.

[NogDog]

That sort of thing is very common. You can either loop through the query result set to output the HTML <option> elements, or else to dump the results into an array which you can then loop through later as needed with a foreach() loop to output the options.

$sql = "SELECT `id`, `name` FROM `subject` ORDER BY `name`";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)) {
   printf("<option value='%d'>%s</option>\n", $row['id'], htmlspecialchars($row['name']));
}

[axman288]

how do you add the code in a <select> field?

[NogDog]

<select name='foo'>
<?php
// the code in the previous reply
?>
</select>

😉