Generating dynamic checkboxes - MySQL

[Trent_Hatred]

Issue:

I have 8 fields at the end of a table in my MySQL database labelled rst_HP, rst_PUB etc. They are enum y/n fields.

How would I go about displaying those 8 fields as checkboxes via a php statement?

I'm trying to wrap my head around it...

One problem that I can foresee is, how do I select just the fields that start with "rst_" from the table?

Thanks much,
B

[LordShryku]

Use [man]mysql_list_fields[/man] to get a list of the fields in the table, then use [man]substr[/man] to see if they start with rst_