Authors list from DB

[cmccomas]

Just curious if I could do this:

Have a add news page, with headline, article, and author, but for the author part use a drop-down window to select which author is writing the story. The names for authors would be stored in the same table, or a different table, but the options are retrieved from the database.

So, if I have Chris and Jim as the authors, they are saved in a field in the table. Then if I add a person to the table, Skip, can I set the option field to read from that field? So, I don't have to edit the hardcode each time to add a new person?

[erikwebb]

yes, that is what i, and i assume most db programmers, do. just fetch every author from the other table and output a new option field for each author:

print "<option value=\"$author_name\">$author_name</option>";

[cmccomas]

Thank you tons!